[no subject]
help
Re: RE: oracle or mssql
y > > the correct reads. Oracle method IS the dirty read. > > > > I am sure that your users does at least 1000 commits to every rollback. > > So when oracle gives you the data it already knows that this data is > > wrong. If you do the query again a minute later you will get new results > > that were available when you did the original query but were committed > > later. So you get a 1000/1 chance to get incorrect data. > > > > The "dirty read" method, on the other hand, gives you the current values, > > believing that they will be committed in a moment. So you get 1/1000 > > chance > > to get wrong data. > > > > Which odds will you bet on? > > > > Yechiel Adar > > Mehish > > - Original Message - > > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > > Sent: Tuesday, October 29, 2002 2:18 PM > > > > > > List, > > I'm always keen to refresh on database comparisons so thanks for > > everyone's pointers. > > > > I'm surprised Oracle doesn't make more of an issue about their locking and > > concurrency methods (i.e. redo/rollback/undo). > > > > MSSQL seems to deal with it in two ways: > > Default: readers and writers prevent writers from accessing data until > > they > > are finished with it! > > Other method: no control, you just get dirty reads! > > > > Anyone got anything to add to this? Or am I wrong? > > > > - Mike. > > > > > > -Original Message- > > Sent: 24 October 2002 17:29 > > To: Multiple recipients of list ORACLE-L > > > > > > As I said, use mssql ONLY if your boss is willing to be strapped into a > > MicroSlop only platform. If he's even remotely thinking of using a > > different OS > > then you can't use mssql. > > > > Dick Goulet > > > > Reply Separator > > Author: [EMAIL PROTECTED] > > Date: 10/23/2002 11:48 PM > > > > goodmorning > > everybody who responded to my basic question : thanks > > > > summary > > > > professional : use oracle enterprise edition > > semi professional : use oracle standard edition / mssql enterprise edition > > in all other cases mssql standard edition > > > > > > > > > -Oorspronkelijk bericht- > > > Van: Mohammad Rafiq [SMTP:[EMAIL PROTECTED]] > > > Verzonden:woensdag 23 oktober 2002 20:51 > > > Aan: Multiple recipients of list ORACLE-L > > > Onderwerp:RE: oracle or mssql > > > > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: Jenner Mike > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > > San Diego, California-- Mailing list and web hosting services > > - > > To REMOVE yourself from this mailing list, send an E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > > the message BODY, include a line containing: UNSUB ORACLE-L > > (or the name of mailing list you want to be removed from). You may > > also send the HELP command for other information (like subscribing). > > > > -- > > > Live Life in Broadband > > www.telewest.co.uk > > > > > > The information transmitted is intended only for the person or entity to > which it is addressed and may contain confidential and/or privileged > material. > > Statements and opinions expressed in this e-mail may not represent those > of the company. Any review, retransmission, dissemination or other use of, > or taking of any action in reliance upon, this information by persons or > entities other than the intended recipient is prohibited. If you received > this in error, please contact the sender immediately and delete the material > from any computer. > > > > > > > > == > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: Adrian Roe > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > > San Diego, California-- Mailing list and web hosting services > > - > > To REMOVE
Re: Convert DM TSP to LM TSP w/ lots of data
L PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tom Pall INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tom Pall INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: What's your opinion: ALL_ROWS vs FIRST_ROWS
I guess that's why when I take a look at the initialization files of databases in large shops where it's expected the DBAs know what they're doing, by and large the databases are running in CHOOSE (all rows if there are sufficient statistics) mode. - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Wednesday, October 30, 2002 11:19 AM > We have an OLTP system that I thought will benefit from first rows. > The sad fact is that when I set optimization to first rows the response > sucks. > > Do some testing, as you can change this anytime. > > Yechiel Adar > Mehish > - Original Message - > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > Sent: Tuesday, October 29, 2002 11:13 PM > > > > We're moving from RBO to CBO. > > > > For those of you who use CBO, what mode do you use FIRST_ROWS or ALL_ROWS? > > And why? > > > > My thinking is if it's a database where most of the querying is done on > > small sets of records, then we may want to use FIRST_ROWS. On the other > > hand, if our database is used to generate sizable reports, we might use > > ALL_ROWS. > > > > I also understand that we can always change it per session (with alter > > session) and per query (with hints). > > > > Michael Armstead > > Principal Database Administrator, OCP-Certified > > World Wide Corporate IT Database Administration > > GlaxoSmithKline > > > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: Armstead, Michael A > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > > San Diego, California-- Mailing list and web hosting services > > - > > To REMOVE yourself from this mailing list, send an E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > > the message BODY, include a line containing: UNSUB ORACLE-L > > (or the name of mailing list you want to be removed from). You may > > also send the HELP command for other information (like subscribing). > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Yechiel Adar > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tom Pall INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Mixing OLTP with DSS
Oracle 8i uses a different aging algorithm than before. It waits for blocks to be accessed several times before considering keeping them around. That way the full scan of a big table won't push other tables out. If aging becomes a problem, remember you can now size a keep and recycle buffer pool (The names only suggest the buffers' intended purposes. Each follows the same aging algorithm.) and can alter table/index/partition to assign it a new buffer cache online. If the data OLTP and DSS don't have to be accessed in the same query, it makes sense to create a new database to contain the OLTP data. Not only will the caches be separate, their rollback, redo and process will be separate as well. Plus, you'll be able to backup or take one down without bothering the other one. If the data has to be accessed together, you'll have to weigh the impact using database links in with the other pros and cons of creating a separate database. - Original Message - From: Rick Stephenson To: Multiple recipients of list ORACLE-L Sent: Tuesday, October 29, 2002 12:19 PM Subject: Mixing OLTP with DSS Am I looking for trouble by mixing an OLTP type database with a DSS type database? I currently have a relatively small database that is used for quick lookup type actions. The company wants to add a much bigger and constantly growing application for historical reporting on the same machine. Should I create another instance or keep it in the same instance? Keeping it in the same instance would seem to defeat having anything cached seeing that the large reports will flush out the cache each and every time. I am running Oracle 8.1.7, on Solaris 2.8. Any suggestions would be helpful. Thanks, Rick Stephenson
Re: 1 Volume of Software RAID 1+0 versus Multiple Volumes of Software Raid
Ah yes. The eternal argument between the DBA, who likes things separate,and the SA, who likes big smears (But it's mirrored!).- Original Message -From: <[EMAIL PROTECTED]>To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>Sent: Tuesday, October 29, 2002 3:43 PMSubject: Re: 1 Volume of Software RAID 1+0 versus Multiple Volumes ofSoftware Raid> I would go with 3 RAID 1's given the choice.>> Not necessarily for performance though.>> This would allow you to have 3 control files on separate drives.>> It would also allow soft mirroring of the redo logs.>> And before someone jumps in with "But you don't need> to mirror them on RAID 1", I *like* having them in 2 locations. :)>> As for performance, it is nice to separate the redo as much as possible.>>> Jared>>> "VIVEK_SHARMA" <[EMAIL PROTECTED]>> Sent by: [EMAIL PROTECTED]> 07/11/2002 06:43 AM> Please respond to ORACLE-L>>> To: Multiple recipients of list ORACLE-L<[EMAIL PROTECTED]>> cc:> Subject: 1 Volume of Software RAID 1+0 versus MultipleVolumes of Software Raid 1> ? For performance , Which Option is better :->> Given 6 Internal FCAL Hard Disks ?> 1) Creating 1 Volume with Software RAID 1+0 OR> 2) Creating 3 Volumes of Software RAID 1 , Each Volume Containing 2 Disks> & Manually Spreading the Database> across the 3 Volumes ?>> Solaris 8> Machine V880 model>> --> Please see the official ORACLE-L FAQ: http://www.orafaq.com> --> Author: VIVEK_SHARMA> INET: [EMAIL PROTECTED]>> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051> San Diego, California -- Public Internet access / Mailing Lists> > To REMOVE yourself from this mailing list, send an E-Mail message> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in> the message BODY, include a line containing: UNSUB ORACLE-L> (or the name of mailing list you want to be removed from). You may> also send the HELP command for other information (like subscribing). --> Please see the official ORACLE-L FAQ: http://www.orafaq.com> --> Author:> INET: [EMAIL PROTECTED]>> Fat City Network Services -- 858-538-5051 http://www.fatcity.com> San Diego, California -- Mailing list and web hosting services> -> To REMOVE yourself from this mailing list, send an E-Mail message> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in> the message BODY, include a line containing: UNSUB ORACLE-L> (or the name of mailing list you want to be removed from). You may> also send the HELP command for other information (like subscribing).
Re: Convert DM TSP to LM TSP w/ lots of data
retted it. I've not done a rigorous benchmark but can tell you from casual observation dropping an object with lots of extents doesn't happen in the blink of an eye but doesn't lock out all other space allocation as UET/FET weren't constantly in use and the ST enque wasn't locked for exclusive use. It's prudent to follow Oracle's recommendations if conditions permit. Create a new LMT and move your data to it. - Original Message - To: Multiple <mailto:ORACLE-L@;fatcity.com> recipients of list ORACLE-L Sent: Monday, October 28, 2002 8:43 PM I am reposting this. Has anyone tried to convert a dictionary managed table space containing lots of data to locally managed? We have tried this out successfully on empty table spaces or created a new LMT tablespace and moved the existing objects to it. Thanks, Govind -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tom Pall INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: RE: oracle or mssql
http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jenner Mike INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tom Pall INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Oracle Internals course
Title: Message Oracle didn't start offering instruction directly at your desktop or urge you to open up an iTAR instead of talking to a Customer Service person for nothing. People are expensive. - Original Message - From: Bob Metelsky To: Multiple recipients of list ORACLE-L Sent: Tuesday, October 29, 2002 8:33 AM Subject: RE: Oracle Internals course It is just me or does 500-2000 per day seem a little "steep"? Oracle8i: Everything You Always Wanted to Know about the Optimizer Instructor-Led inClass US$ 500 1 Day English English OR INTRODUCTION TO ORACLE9I: SQL (ILT) BLOOMFIELD, CT 02-DEC-02 US$2000 Remove from Shopping Cart INTRODUCTION TO ORACLE 8I: SQL AND PL/SQL (ILT) BLOOMFIELD, CT 17-FEB-03 US$2000 Remove from Shopping Cart ADVANCED PL/SQL (ILT) BLOOMFIELD, CT 07-NOV-02 US$1000 Remove from Shopping Cart
Re: List of Rows Updated
Title: RE: List of Rows Updated Gosh. I wish I worked in your shop. I'm typically asked to produce an audit report for yesterday on a table I didn't even know existed. "What do you mean you can't do that? Aren't you an Oracle DBA?" - Original Message - From: Jamadagni, Rajendra To: Multiple recipients of list ORACLE-L Sent: Tuesday, October 29, 2002 5:58 AM Subject: RE: List of Rows Updated Auditing is much simpler and usable than logminer for *this purpose*. Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! -Original Message- From: Tom Pall [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 29, 2002 1:39 AM To: Multiple recipients of list ORACLE-L Subject: Re: List of Rows Updated Logminer comes to mind. - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Monday, October 28, 2002 10:23 PM > Hi, > I want to get the list of rows which were updated(then commited) in a > particular table say X on a specific date e.g yesterday. > Is this possible and how ? > > Thanks > Manoj.
Re: Oracle Internals course
No. Scott said he's been to a number of Pacific Ocean countries to teach the course. I suspect those courses where hosted by a company which had offered enough internal enrollment. As I recall, there's another instructor who also teaches the Internals, Crashes/Dump/Traces and Backup/Recovery seminars. Be careful of all Oracle courses. Some of them are subcontracted out. I don't warn you to put down consultants. But this thread has been about Scott and his internals course. Scott's the star. If you really want to make sure Scott's going to teach your course, phone him up or drop him an email. Don't expect him to respond the same day you try to contact him. When he's teaching, he's tied up through lunch and dinner and sometimes even on the ride to the airport. Many people go to the course with specific questions they want answered. Scott often handles those during out of class hours. - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Tuesday, October 29, 2002 5:58 AM Are these Internals classes only available in the US? -Original Message- Carmichael Sent: 29 October 2002 11:04 To: Multiple recipients of list ORACLE-L Tom, I didn't mean to imply that you were going into damagement! I was lucky enough to have someone point me to "seminars" and figured I'd share my luck. I think the reason they don't publicize it is that he is the only one teaching it and it's full without publicizing. Can you imagine if they made it generally available? He'd have time to do nothing else! Rachel --- Tom Pall <[EMAIL PROTECTED]> wrote: > Rachel, I'm not bucking for a management slot by being clueless about > the > details. Really I'm not. I registered online for the internals > course by > searching for it. I just kind of assumed from what Scott said that I > just > managed to luck out when I searched for the course and found it. I > mistakenly assumed the course was quietly being removed from online > registration after hearing Scott's statements about hiding and not > publicizing the course. > - Original Message - > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > Sent: Monday, October 28, 2002 8:58 PM > > > > I registered for it online, at education.oracle.com > > > > you have to search on seminars, not classes. It's difficult to > find, > > but it IS there > > > > > > --- Tom Pall <[EMAIL PROTECTED]> wrote: > > > RE: Oracle Internals courseThat rumor's been going on for > versions > > > now. As has been Scott's desire to offer a two week internals > > > course. Course participants would sign all sorts of > non-disclosure > > > forms then get a scaled down version of what's taught to Customer > > > Support. Wait a minute! Customer Support takes these courses? > Surely > > > not all the Silver Support people I've called. A difficulty with > a > > > two week course is that the very DBAs most likely to benefit from > the > > > course are the ones least likely to be let free for two weeks. > > > > > > The internals course is slated to be yanked every time a new > version > > > of Oracle comes out. Why teach internals when there are no > > > initialization parameters and the database maintains and tunes > > > itself? There's been an economic downturn and Oracle DBAs have > lost > > > their jobs. But anybody know an Oracle DBA who lost his job > because > > > a later version doesn't require a DBA? Oracle on CDs 1,2 and 3, > huh? > > > I think if I dig enough I can find that old version of Oracle I > had > > > that came on a single diskette. > > > > > > Scott says the internals course is purposely hidden. You have to > > > call Oracle directly and ask for it. A number of people > registered > > > for the course from the paper or online catalogs, showed up then > > > complained that they weren't about to get anything out of the > > > course.. > > > - Original Message - > > > From: Nick Wagner > > > To: Multiple recipients of list ORACLE-L > > > Sent: Monday, October 28, 2002 3:23 PM > > > Subject: RE: Oracle Internals course > > > > > > > > > rumor has it that this course is not going to be > offered/modified > > > for the 9.2 release of Oracle. Can anyone confirm or deny it? > > > > > > Nick > > > > > > p.s. Had a close friend take this class, and they also came > back &g
Re: List of Rows Updated
Logminer comes to mind. - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Monday, October 28, 2002 10:23 PM > Hi, > I want to get the list of rows which were updated(then commited) in a > particular table say X on a specific date e.g yesterday. > Is this possible and how ? > > Thanks > Manoj. > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tom Pall INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Convert DM TSP to LM TSP w/ lots of data
I tried having Oracle convert DMT to LMT out a few times on 10 GB tablespaces. Whether or not that's a lot of data depends on you. Worked like a champ. And this was in the early days of LMT. People who pay a lot of attention to the internals will warn you that converting a DMT to LMT is not optimal. Your bitmaps wind up at the end of the files instead of the headers. I've read posts here and elsewhere where people worried about the same issues as they did with DMT. They wanted to limit the number of extents segments grew to by creating tablespaces with different sized fixed extents. A DBA I worked with pointed out how very easy and quickly things worked with letting Oracle automatically size the next extent. I've gone that way whenever possible and have never regretted it. I've not done a rigorous benchmark but can tell you from casual observation dropping an object with lots of extents doesn't happen in the blink of an eye but doesn't lock out all other space allocation as UET/FET weren't constantly in use and the ST enque wasn't locked for exclusive use. It's prudent to follow Oracle's recommendations if conditions permit. Create a new LMT and move your data to it. - Original Message - From: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L Sent: Monday, October 28, 2002 8:43 PM Subject: Convert DM TSP to LM TSP w/ lots of data I am reposting this. Has anyone tried to convert a dictionary managed table space containing lots of data to locally managed? We have tried this out successfully on empty table spaces or created a new LMT tablespace and moved the existing objects to it. Thanks, Govind
Re: Oracle Internals course
Rachel, I'm not bucking for a management slot by being clueless about the details. Really I'm not. I registered online for the internals course by searching for it. I just kind of assumed from what Scott said that I just managed to luck out when I searched for the course and found it. I mistakenly assumed the course was quietly being removed from online registration after hearing Scott's statements about hiding and not publicizing the course. - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Monday, October 28, 2002 8:58 PM > I registered for it online, at education.oracle.com > > you have to search on seminars, not classes. It's difficult to find, > but it IS there > > > --- Tom Pall <[EMAIL PROTECTED]> wrote: > > RE: Oracle Internals courseThat rumor's been going on for versions > > now. As has been Scott's desire to offer a two week internals > > course. Course participants would sign all sorts of non-disclosure > > forms then get a scaled down version of what's taught to Customer > > Support. Wait a minute! Customer Support takes these courses? Surely > > not all the Silver Support people I've called. A difficulty with a > > two week course is that the very DBAs most likely to benefit from the > > course are the ones least likely to be let free for two weeks. > > > > The internals course is slated to be yanked every time a new version > > of Oracle comes out. Why teach internals when there are no > > initialization parameters and the database maintains and tunes > > itself? There's been an economic downturn and Oracle DBAs have lost > > their jobs. But anybody know an Oracle DBA who lost his job because > > a later version doesn't require a DBA? Oracle on CDs 1,2 and 3, huh? > > I think if I dig enough I can find that old version of Oracle I had > > that came on a single diskette. > > > > Scott says the internals course is purposely hidden. You have to > > call Oracle directly and ask for it. A number of people registered > > for the course from the paper or online catalogs, showed up then > > complained that they weren't about to get anything out of the > > course.. > > - Original Message - > > From: Nick Wagner > > To: Multiple recipients of list ORACLE-L > > Sent: Monday, October 28, 2002 3:23 PM > > Subject: RE: Oracle Internals course > > > > > > rumor has it that this course is not going to be offered/modified > > for the 9.2 release of Oracle. Can anyone confirm or deny it? > > > > Nick > > > > p.s. Had a close friend take this class, and they also came back > > extremely pleased with it. > > > > -Original Message- > > From: Rachel Carmichael [mailto:wisernet100@;yahoo.com] > > Sent: Monday, October 28, 2002 12:19 PM > > To: Multiple recipients of list ORACLE-L > > Subject: Re: Oracle Internals course > > > > > > > > Scott is the "instructors's instructor" > > > > he learns the new features, then teaches them to the instructors so > > > > they can teach them to you > > > > I had the pleasure of taking those classes with Scott a few years > > ago > > as well. He's a great teacher. > > > > If he is ever presenting at any conference you go to, GO SEE HIM > > > > --- Tom Pall <[EMAIL PROTECTED]> wrote: > > > I took that very course with Scott a few years ago. Yup, Scott > > flies > > > through the Internals and Dump/Traces courses with lots of extra > > > material to > > > spare. It's really refreshing to hear him tell the class how the > > > > > developers > > > documented something then tell how it's actually built. He keeps > > a > > > database > > > running in his notebook to prove what he says. Scott's one great > > > > > teacher. > > > - Original Message - > > > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > > > > > Sent: Monday, October 28, 2002 12:53 PM > > > > > > > > > I just wanted to say... > > > > > > If you have a chance to take the Oracle Internals course with > > Scott > > > Gossett > > > at Oracle, I highly recommend it. > > > > > > I wish I knew half of what he knows! > > > > > > The course isn't included in the OCP tracks, I think i
Re: Oracle Internals course
Title: RE: Oracle Internals course Meaning you're not planning on letting your DBA go because Oracle now has now no initialization parameters to tweak (Wrong!), is self configuring, self maintaining, self tuning, self repairing? - Original Message - From: Khedr, Waleed To: Multiple recipients of list ORACLE-L Sent: Monday, October 28, 2002 6:58 PM Subject: RE: Oracle Internals course I think the external visible Oracle stuff are enough to keep any DBA busy these days:) -Original Message-From: Tom Pall [mailto:[EMAIL PROTECTED]]Sent: Monday, October 28, 2002 5:24 PMTo: Multiple recipients of list ORACLE-LSubject: Re: Oracle Internals course That rumor's been going on for versions now. As has been Scott's desire to offer a two week internals course. Course participants would sign all sorts of non-disclosure forms then get a scaled down version of what's taught to Customer Support. Wait a minute! Customer Support takes these courses? Surely not all the Silver Support people I've called. A difficulty with a two week course is that the very DBAs most likely to benefit from the course are the ones least likely to be let free for two weeks. The internals course is slated to be yanked every time a new version of Oracle comes out. Why teach internals when there are no initialization parameters and the database maintains and tunes itself? There's been an economic downturn and Oracle DBAs have lost their jobs. But anybody know an Oracle DBA who lost his job because a later version doesn't require a DBA? Oracle on CDs 1,2 and 3, huh? I think if I dig enough I can find that old version of Oracle I had that came on a single diskette. Scott says the internals course is purposely hidden. You have to call Oracle directly and ask for it. A number of people registered for the course from the paper or online catalogs, showed up then complained that they weren't about to get anything out of the course.. - Original Message - From: Nick Wagner To: Multiple recipients of list ORACLE-L Sent: Monday, October 28, 2002 3:23 PM Subject: RE: Oracle Internals course rumor has it that this course is not going to be offered/modified for the 9.2 release of Oracle. Can anyone confirm or deny it? Nick p.s. Had a close friend take this class, and they also came back extremely pleased with it. -Original Message- From: Rachel Carmichael [mailto:[EMAIL PROTECTED]] Sent: Monday, October 28, 2002 12:19 PM To: Multiple recipients of list ORACLE-L Subject: Re: Oracle Internals course Scott is the "instructors's instructor" he learns the new features, then teaches them to the instructors so they can teach them to you I had the pleasure of taking those classes with Scott a few years ago as well. He's a great teacher. If he is ever presenting at any conference you go to, GO SEE HIM --- Tom Pall <[EMAIL PROTECTED]> wrote: > I took that very course with Scott a few years ago. Yup, Scott flies > through the Internals and Dump/Traces courses with lots of extra > material to > spare. It's really refreshing to hear him tell the class how the > developers > documented something then tell how it's actually built. He keeps a > database > running in his notebook to prove what he says. Scott's one great > teacher. > - Original Message - > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > Sent: Monday, October 28, 2002 12:53 PM > > > I just wanted to say... > > If you have a chance to take the Oracle Internals course with Scott > Gossett > at Oracle, I highly recommend it. > > I wish I knew half of what he knows! > > The course isn't included in the OCP tracks, I think it should be > given a > higher profile though. > > Regards, > Patrice Boivin > Systems Analyst (Oracle Certified DBA) > > Systems Admin & Operations | Admin. et Exploit. des systèmes > Technology Services | Services technologiques > Informatics Branch | Direction de l'informatique > Maritimes Region, DFO | Région des Maritimes, MPO > > E-Mail: [EMAIL PROTECTED] > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com &
Re: Oracle Internals course
Title: RE: Oracle Internals course That rumor's been going on for versions now. As has been Scott's desire to offer a two week internals course. Course participants would sign all sorts of non-disclosure forms then get a scaled down version of what's taught to Customer Support. Wait a minute! Customer Support takes these courses? Surely not all the Silver Support people I've called. A difficulty with a two week course is that the very DBAs most likely to benefit from the course are the ones least likely to be let free for two weeks. The internals course is slated to be yanked every time a new version of Oracle comes out. Why teach internals when there are no initialization parameters and the database maintains and tunes itself? There's been an economic downturn and Oracle DBAs have lost their jobs. But anybody know an Oracle DBA who lost his job because a later version doesn't require a DBA? Oracle on CDs 1,2 and 3, huh? I think if I dig enough I can find that old version of Oracle I had that came on a single diskette. Scott says the internals course is purposely hidden. You have to call Oracle directly and ask for it. A number of people registered for the course from the paper or online catalogs, showed up then complained that they weren't about to get anything out of the course.. - Original Message - From: Nick Wagner To: Multiple recipients of list ORACLE-L Sent: Monday, October 28, 2002 3:23 PM Subject: RE: Oracle Internals course rumor has it that this course is not going to be offered/modified for the 9.2 release of Oracle. Can anyone confirm or deny it? Nick p.s. Had a close friend take this class, and they also came back extremely pleased with it. -Original Message- From: Rachel Carmichael [mailto:[EMAIL PROTECTED]] Sent: Monday, October 28, 2002 12:19 PM To: Multiple recipients of list ORACLE-L Subject: Re: Oracle Internals course Scott is the "instructors's instructor" he learns the new features, then teaches them to the instructors so they can teach them to you I had the pleasure of taking those classes with Scott a few years ago as well. He's a great teacher. If he is ever presenting at any conference you go to, GO SEE HIM --- Tom Pall <[EMAIL PROTECTED]> wrote: > I took that very course with Scott a few years ago. Yup, Scott flies > through the Internals and Dump/Traces courses with lots of extra > material to > spare. It's really refreshing to hear him tell the class how the > developers > documented something then tell how it's actually built. He keeps a > database > running in his notebook to prove what he says. Scott's one great > teacher. > - Original Message - > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > Sent: Monday, October 28, 2002 12:53 PM > > > I just wanted to say... > > If you have a chance to take the Oracle Internals course with Scott > Gossett > at Oracle, I highly recommend it. > > I wish I knew half of what he knows! > > The course isn't included in the OCP tracks, I think it should be > given a > higher profile though. > > Regards, > Patrice Boivin > Systems Analyst (Oracle Certified DBA) > > Systems Admin & Operations | Admin. et Exploit. des systèmes > Technology Services | Services technologiques > Informatics Branch | Direction de l'informatique > Maritimes Region, DFO | Région des Maritimes, MPO > > E-Mail: [EMAIL PROTECTED] > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Boivin, Patrice J > INET: [EMAIL PROTECTED] > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com > San Diego, California -- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Tom Pall > INET: [EMAIL PROTECTED] > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com > San Diego, California -- Mailing list and web hosting services > - > To REMO
Re: Location of Trace file
Oracle9i Enterprise Edition Release 9.2.0.1.0 - ProductionWith the Partitioning, OLAP and Oracle Data Mining optionsJServer Release 9.2.0.1.0 - Productionon Microsoft Window 2000 5.00.2195 Service Pack 3.I have no registry entry for a pfile or ifile. Since I have no ifile, thequeryShow parameter ifilereturns a null string.oracle\ora92\database contains the file SPFILETOM.ORA (this is 9i,remember).oracle\admin\tom\pfile contains init.ora.9212002185826.TOM is the database sid.It looks like the Oracle installer for 9i did away with the single linepfile it created in Oracle 8i. It also looks like Oracle expects to findthe spfile ORACLE_HOME\database. ORACLE_HOME is defined in the registry.- Original Message -From: "Yechiel Adar" <[EMAIL PROTECTED]>To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>Sent: Monday, October 28, 2002 12:25 PMSubject: Re: Location of Trace file> I just built a new database for 8.1.6 on win2000.> In oracle\ora81\database there is init.ora file for the database.> This file contains only ifile=\oracle\admin\\pfile\init.ora.>> But - The registery entry for pfile point directly to:> \oracle\admin\\pfile\init.ora>> so ifile value is empty.>> If you are on windows check that values in the registery for oracle home.> Look for name=ora__pfile. The value points to the pfile.>> Yechiel Adar> Mehish> - Original Message -> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>> Sent: Saturday, October 26, 2002 5:43 PM>>> > My query was executed on an Oracle installed, Oracle created Oracle 9i> > version 2 database on Windows 2000. Oracle really started following OFA> on> > Windows starting with version 8i.> > - Original Message -> > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>> > Sent: Friday, October 25, 2002 1:04 PM> >> >> > >> > > If you follow OFA, it works for NT ;-)> > >> > >> > >> > >> > >> > > "Tom Pall"> > > <tpall@realti To: Multiple recipientsof> > list ORACLE-L <[EMAIL PROTECTED]>> > > me.net> cc:> > > Sent by: Subject: Re: Location of> > Trace file> > > root@fatcity.> > > com> > >> > >> > > October 25,> > > 2002 12:58 PM> > > Please> > > respond to> > > ORACLE-L> > >> > >> > >> > >> > >> > >> > > Show parameter ifile shows the ifile address, not the pfile address.> > >> > > Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production> > > With the Partitioning, OLAP and Oracle Data Mining options> > > JServer Release 9.2.0.1.0 - Production> > >> > > SQL> show parameter ifile> > >> > > NAME TYPE VALUE> > > ---> > > ---> > > ---> > > ifile> > > file> > >> > > SQL> show parameter background_dump_dest> > >> > > NAME TYPE VALUE> > > ---> > > ---> > > ---> > > background_dump_dest string> C:\oracle\admin\tom\bdump> > > - Original Message -> > > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>> > > Sent: Friday, October 25, 2002 4:12 AM> > >> > >> > > > Manoj,> > > >> > > > svrmgrl > show parameter ifile> > > >> > > > will give u the location of init.ora and> > > >> > > > svrmgrl > show parameter background_dump_dest> > > > svrmgrl > show parameter user_dump_dest> > > >> > > > will give u the location of alert and trace files respectively.> > > >> > > > HTH.> > > > Jp.> > >> > >> > > --> > > Please see the official ORACLE-L FAQ: http://www.orafaq.com> > > --> > > Author:> > > INET: [EMAIL PROTECTED]> > >> > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com> > > San Die
Re: Re:[Q] what kind of documents shoud contractor provide to m
Do some checking. These are typical deliverables. The key is whether or not the documentation is AS DESIGNED or AS DELIVERED. - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Monday, October 28, 2002 12:53 PM > Only those listed as deliverables. Now you should have listed a database design > document, data dictionary, users manuals, maintenance manuals, and commented > code. > > Dick Goulet > > Reply Separator > Author: "dist cash" <[EMAIL PROTECTED]> > Date: 10/28/2002 10:13 AM > > > > We have a application use ORACLE 8.1.6 and Forms 6i. This project going > to finish soon. Can anyone tell me what kind of documents should > contractor provide to us before they leave? > > > Thanks. > > > > > > _ > Protect your PC - get McAfee.com VirusScan Online > http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963 > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: dist cash > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tom Pall INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Oracle Internals course
I took that very course with Scott a few years ago. Yup, Scott flies through the Internals and Dump/Traces courses with lots of extra material to spare. It's really refreshing to hear him tell the class how the developers documented something then tell how it's actually built. He keeps a database running in his notebook to prove what he says. Scott's one great teacher. - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Monday, October 28, 2002 12:53 PM I just wanted to say... If you have a chance to take the Oracle Internals course with Scott Gossett at Oracle, I highly recommend it. I wish I knew half of what he knows! The course isn't included in the OCP tracks, I think it should be given a higher profile though. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin & Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tom Pall INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: BUG 2632931 on 9.2.0.2
Title: RE: BUG 2632931 on 9.2.0.2 "C" what side effects you have to consider when choosing a programming language? - Original Message - From: Jamadagni, Rajendra To: Multiple recipients of list ORACLE-L Sent: Monday, October 28, 2002 12:38 PM Subject: RE: BUG 2632931 on 9.2.0.2 What's new in Oracle processes leaking memory ...? Looks like they shouldn't follow microslop in this regards at-least. Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, October 28, 2002 1:19 PM To: Multiple recipients of list ORACLE-L Subject: RE: BUG 2632931 on 9.2.0.2 Excuse my French but that !!@@# -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, October 28, 2002 12:44 PM To: Multiple recipients of list ORACLE-L Subject: Re: BUG 2632931 on 9.2.0.2 native_threads process associated with 9.2.0 OEM OMS is leaking memory. Process starts out about 8 MB and keeps growing. Up to 28.93 MB after less than 1 hour. Workaround: None
Re: Experience with Quest Shareplex
I did some investigation into SharePlex a few years ago. I tried for months to get someone to respond to email and voicemail messages to the vendor that "I want to buy SharePlex and I have the money". Eventually I got the software for evaluation. I found once again that replication isn't easy, no matter which approach or vendor you use. My own playing around with SharePlex, talks with noted Oracle book authors and email exchanges with SharePlex users who responded to my query on this listserver privately honed in on one problem: getting synchronized and ready to start replicating. SharePlex would synch up table after table, find one it couldn't synch up and fail. Like anything with Oracle, see if Oracle's solution fits your needs first. It's nice only having to go to one vendor for support. SharePlex costs a lot of money. Make sure you've got your requirements firm. After all of my investigating, the company I did the work for decided they could live with reporting databases created by breaking a third mirror, exporting the filesystems from the production box, importing them into the reporting box. If you really need the capability of SharePlex, well, it does have a lot of happy customers. Be prepared, as they were, to spend lots of time getting it right. - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Monday, October 28, 2002 10:13 AM > Does anyone have experience with a product called Shareplex > by Quest Software. We have some remote access performance > issues and my management is looking at this product > as a possible solution for a distributed database. > > thanks, > Peter Schauss > Northrop Grumman Corporation > [EMAIL PROTECTED] > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Schauss, Peter > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tom Pall INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Location of Trace file
My query was executed on an Oracle installed, Oracle created Oracle 9i version 2 database on Windows 2000. Oracle really started following OFA on Windows starting with version 8i. - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Friday, October 25, 2002 1:04 PM > > If you follow OFA, it works for NT ;-) > > > > > > "Tom Pall" > > me.net> cc: > Sent by: Subject: Re: Location of Trace file > root@fatcity. > com > > > October 25, > 2002 12:58 PM > Please > respond to > ORACLE-L > > > > > > > Show parameter ifile shows the ifile address, not the pfile address. > > Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production > With the Partitioning, OLAP and Oracle Data Mining options > JServer Release 9.2.0.1.0 - Production > > SQL> show parameter ifile > > NAME TYPEVALUE > --- > --- > --- > ifile > file > > SQL> show parameter background_dump_dest > > NAME TYPEVALUE > --- > --- > --- > background_dump_dest string C:\oracle\admin\tom\bdump > - Original Message - > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > Sent: Friday, October 25, 2002 4:12 AM > > > > Manoj, > > > > svrmgrl > show parameter ifile > > > > will give u the location of init.ora and > > > > svrmgrl > show parameter background_dump_dest > > svrmgrl > show parameter user_dump_dest > > > > will give u the location of alert and trace files respectively. > > > > HTH. > > Jp. > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tom Pall INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: SQL*Plus COPY error
I've not seen this particular error. Over the years I've found SQL*Plus COPY to be buggy. I just did a search on Metalink for "sqlplus copy error". Your problem is not addressed directly, but other problems point to bugs in the GUI version of SQL*PLUS. Oracle's advice is to use the command line, non-GUI version of SQL*Plus for COPY. - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Friday, October 25, 2002 12:54 PM > I'm trying to use (for the first time in 15 years of Oracle > experience!) SQL*Plus COPY, and am receiving the following > incomprehensible error: > > SQL> @odss/cmsr > > Array fetch/bind size is 100. (arraysize is 100) > Will commit after every 10 array binds. (copycommit is 10) > Maximum long size is 2. (long is 2) > > ERROR: > ORA--3393898: Message -3393898 not found; product=RDBMS; facility=ORA > > Anyone seen this or anything like it? My environment is set up > properly; i.e., errors returned by operations other than COPY display > the way they're supposed to. > > TIA! > > > __ > Do you Yahoo!? > Y! Web Hosting - Let the expert host your web site > http://webhosting.yahoo.com/ > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Paul Baumgartel > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tom Pall INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Location of Trace file
The most common reason is that you are not logged on the system as the user and group that owns the $ORACLE_HOME/bin/oracle executable. You also need to have ORACLE_HOME and ORACLE_SID set appropriately. - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Friday, October 25, 2002 4:43 AM > Hi, >when I connect to internal using svrmgrl,it asks for password. > I do not know the password. > > > Regards, > Manoj. > > -Original Message- > Sent: Friday, October 25, 2002 1:44 PM > To: ORACLE-L > Cc: oraoraora; Manoj, COSLTEMP-G > > > Manoj, > > svrmgrl > show parameter ifile > > will give u the location of init.ora and > > svrmgrl > show parameter background_dump_dest > svrmgrl > show parameter user_dump_dest > > will give u the location of alert and trace files respectively. > > HTH. > Jp. > > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tom Pall INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Location of Trace file
Show parameter ifile shows the ifile address, not the pfile address. Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production With the Partitioning, OLAP and Oracle Data Mining options JServer Release 9.2.0.1.0 - Production SQL> show parameter ifile NAME TYPEVALUE --- --- --- ifile file SQL> show parameter background_dump_dest NAME TYPEVALUE --- --- --- background_dump_dest string C:\oracle\admin\tom\bdump - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Friday, October 25, 2002 4:12 AM > Manoj, > > svrmgrl > show parameter ifile > > will give u the location of init.ora and > > svrmgrl > show parameter background_dump_dest > svrmgrl > show parameter user_dump_dest > > will give u the location of alert and trace files respectively. > > HTH. > Jp. > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: oraora oraora > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tom Pall INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Location of Trace file
SQL> select name, value from v$parameter where name='user_dump_dest'; NAME VALUE -- user_dump_dest C:\oracle\admin\tom\udump - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Friday, October 25, 2002 3:08 AM > Hi , > I want to know the location of trace file.I do not know location of > init.ora. > How to get it. > > Thanks > Manoj > > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tom Pall INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
[no subject]
set nomail -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tom Pal INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: SYSTEM TABLESPACE IS SO HUGE ?
from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tom Pall INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Sessions Hang When Not Being Traced/Unhang When Being Traced
Anybody seen this before? Running 8.1.5.0 on Solaris. We have a third party product written in java which runs for a certain amount of time then hangs. I don't see any locks or waits for the applications sessions. This does not happen if I put sql_trace=true in the init file and bounce the database. I can unhang and hang the application sessions using ORADEBUG EVENT 10046 TRACE NAME CONTEXT FOREVER, LEVEL whatever/ORADEBUG EVENT 10046 TRACE NAME CONTEXT OFF. I've searched Metalink's bug database and haven't found any bugs that apply yet.
RE: Another NT question
I believe Oracle on NT/Alpha has fewer bug reports against it than Oracle on NT/Intel. -Original Message- Sent: Tuesday, June 26, 2001 5:12 PM To: Multiple recipients of list ORACLE-L Does it matter NT/Alpha or NT/Intel? -Original Message- Sent: Tuesday, June 26, 2001 5:33 PM To: Multiple recipients of list ORACLE-L Anybody currently have more than 500 concurrent users on an NT box? Just trying to validate a compaq claim that they can handle a large system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shaw, John B INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohan, Ross INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tom Pall INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Another NT question
-Original Message- Sent: Tuesday, June 26, 2001 5:12 PM To: Multiple recipients of list ORACLE-L Does it matter NT/Alpha or NT/Intel? -Original Message- Sent: Tuesday, June 26, 2001 5:33 PM To: Multiple recipients of list ORACLE-L Anybody currently have more than 500 concurrent users on an NT box? Just trying to validate a compaq claim that they can handle a large system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shaw, John B INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohan, Ross INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tom Pall INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: 8.1.6 vs 8.1.7
We're in the process of migrating all of our 8.0.5 to 8.1.6 databases over to 8.1.7.1. We'll be done in a few weeks. We used 8.1.7.0 on our reporting and other non-money making databases since it was released. The few cosmetic issues we had with 8.1.7.0, like v$buffer_pool_statistics being broken, appear fixed in 8.1.7.1. 8.1.7 fixed an almost endless number of bugs we encountered in 8.1.5 and 8.1.6. Sun/Sparc 2.7. -Original Message- Sanmarti Sent: Thursday, April 05, 2001 5:21 PM To: Multiple recipients of list ORACLE-L Hello, I was wondering how stable the Oracle 8i release 3 is. We plan to move our DB in production to the latest version. Has anybody had problems migrating it? I was told by colleges that release 2 looks more stable than the other. How true is that? Any comments ? Thanks in advance, Jordi -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jordi Sanmarti INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tom Pall (E-mail) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
What does _allow_read_only_corruption do?
Yes, I know it's a hidden parameter that should only be used at the advice of counsel and Oracle Support. But has anyone used it? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tom Pall (E-mail) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
SQLServer vs. Oracle Papers Needed
I need pointers to papers/studies that compare and contrast SQLServer vs. Oracle. I'm specifically looking for studies which appear impartial and conclude that Oracle is the better choice. Thanks in advance. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tom Pall (E-mail) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: UPDATE: RE: ERROR: WAITED TOO LONG FOR A ROW CACHE ENQUEUE LOCK! pid=30
Here's a quick excerpt while awaiting a fax number: (page 44) "If v$sysstat shows a significant number of enqueue waits, then a break- down of the resource types for which these waits have been sustained can be obtained from x$ksqst, or from the APT script enqueue_stats.sql. Unfortunately, x$ksqst does not contains (sic.) any indication of the duration of the waits, so care is needed when interpreting these figures. It is sometimes suggested that ENQUEUE_RESOURCES should be increased to combat enqueue waits. But please note that there is absolutely no substance to this suggestion. Oracle will return an ora-52 or Ora-53 error if it fails to find a free slot in the enqueue resources or enqueue locks fixed arrays respectively. Beyond that, the setting of the ENQUEUE_RESOURCES and _ENQUEUE_LOCKS parameters is unimportant. (page 45) The v$resource_limit view should be used to adjust your settings for the ENQUEUE_RESOURCES and _ENQUEUE_LOCKS parameters to ensure that you will not run out of slots in these arrays. You can afford to be generous, because slots in these arrays only take on the order of 72 bytes and 60 bytes respectively. I like to maintain headroom of at least 20% above the maxiumu utilization ever recorded." You probably want to go to the author's we site, which is http://www.ixora.com.au/ and send mail direct to the author, Steve Adams, at [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Monday, February 12, 2001 2:45 PM > I've continued to research this error and found several references on > various search engines. The most promising seems to point this book by > O'Reilly "Oracle8i Internal Services for Waits, Latches, Locks, and Memory". > There is a section (4.4, pg. 42) which talks about enqueue locks, but I > cannot see the text. > > If anyone has this book, could you give the above section a quick read and > let us know what it says about enqueue locks and possible resource > limits/settings for init params. > > THANKS! > > For Kenneth; My version is; Oracle 8.1.6.0.0 and sun Solaris 2.6, as stated > in my original post. > > > -Original Message- > > From: Glenn Travis [mailto:[EMAIL PROTECTED]] > > Sent: Monday, February 12, 2001 11:16 AM > > To: Oracledba@Lazydba. Com; [EMAIL PROTECTED] > > Subject: ERROR: WAITED TOO LONG FOR A ROW CACHE ENQUEUE LOCK! pid=30 > > > > > > The system was not too busy. Processes running were materialized view > > refreshes (stored procs doing rollups, joins, etc...). The > > system was then > > locked up. Some queries could be run, others couldn't. Refreshes never > > completed. I had to alter system kill to release the hang. > > > > Here are the errors: > > > > From the alert file; > > WAITED TOO LONG FOR A ROW CACHE ENQUEUE LOCK! pid=30 > > > > From the udump dir; > > *** SESSION ID:(37.4) 2001-02-11 22:55:18.638 > > >>> WAITED TOO LONG FOR A ROW CACHE ENQUEUE LOCK! <<< > > row cache enqueue: session: 8c184270, mode: N, request: X > > row cache parent object: address=8ac94c10 type=8(dc_objects) > > transaction=8c4b78e4 mode=X flags=002a > > status=VALID/UPDATE/-/-/-/-/-/- > > data= > > ... > > waiting for 'library cache lock' blocking sess=0x0 seq=8105 wait_time=0 > > handle address=8b27869c, lock address=8c629710, > > 10*mode+namespace=15 > > > > - > > Metalink is pretty vague and not much help with this error (some > > say it is a > > VMS enqlm problem, others say it was a bug in v7 and early 8.0). I am > > running 8.1.6 on Solaris 2.6. > > > > As always, any insight would be greatly appreciated. > > > > > > > > Think you know someone who can answer the above question? Forward > > it to them! > > to unsubscribe, send a blank email to [EMAIL PROTECTED] > > to subscribe send a blank email to [EMAIL PROTECTED] > > Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Glenn Travis > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > -------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). Yo
Re: UPDATE: RE: ERROR: WAITED TOO LONG FOR A ROW CACHE ENQUEUE LOCK! pid=30
Please send me ([EMAIL PROTECTED]) a fax number. Too much to type in, don't have ready access to a scanner. - Original Message - To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Monday, February 12, 2001 2:45 PM > I've continued to research this error and found several references on > various search engines. The most promising seems to point this book by > O'Reilly "Oracle8i Internal Services for Waits, Latches, Locks, and Memory". > There is a section (4.4, pg. 42) which talks about enqueue locks, but I > cannot see the text. > > If anyone has this book, could you give the above section a quick read and > let us know what it says about enqueue locks and possible resource > limits/settings for init params. > > THANKS! > > For Kenneth; My version is; Oracle 8.1.6.0.0 and sun Solaris 2.6, as stated > in my original post. > > > -Original Message- > > From: Glenn Travis [mailto:[EMAIL PROTECTED]] > > Sent: Monday, February 12, 2001 11:16 AM > > To: Oracledba@Lazydba. Com; [EMAIL PROTECTED] > > Subject: ERROR: WAITED TOO LONG FOR A ROW CACHE ENQUEUE LOCK! pid=30 > > > > > > The system was not too busy. Processes running were materialized view > > refreshes (stored procs doing rollups, joins, etc...). The > > system was then > > locked up. Some queries could be run, others couldn't. Refreshes never > > completed. I had to alter system kill to release the hang. > > > > Here are the errors: > > > > From the alert file; > > WAITED TOO LONG FOR A ROW CACHE ENQUEUE LOCK! pid=30 > > > > From the udump dir; > > *** SESSION ID:(37.4) 2001-02-11 22:55:18.638 > > >>> WAITED TOO LONG FOR A ROW CACHE ENQUEUE LOCK! <<< > > row cache enqueue: session: 8c184270, mode: N, request: X > > row cache parent object: address=8ac94c10 type=8(dc_objects) > > transaction=8c4b78e4 mode=X flags=002a > > status=VALID/UPDATE/-/-/-/-/-/- > > data= > > ... > > waiting for 'library cache lock' blocking sess=0x0 seq=8105 wait_time=0 > > handle address=8b27869c, lock address=8c629710, > > 10*mode+namespace=15 > > > > - > > Metalink is pretty vague and not much help with this error (some > > say it is a > > VMS enqlm problem, others say it was a bug in v7 and early 8.0). I am > > running 8.1.6 on Solaris 2.6. > > > > As always, any insight would be greatly appreciated. > > > > > > > > Think you know someone who can answer the above question? Forward > > it to them! > > to unsubscribe, send a blank email to [EMAIL PROTECTED] > > to subscribe send a blank email to [EMAIL PROTECTED] > > Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Glenn Travis > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > ---- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tom Pall INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).