Sorry for omitting that info. Version: 8.1.7.4.1 ( maybe patched to 8.1.7.4.6, would have to get on the server to check )
OS: Windows 2000 Server Thanks for the insights John, I hadn't considered that it might actually be a bug, given that this app often has similar issues. There are snapshot logs on the tables involved, though the single session logged in for refresh (CIM_MV in the output) was itself waiting as well. I'll go check on MetaLink later. Jared On Fri, 2003-08-01 at 02:29, John Kanagaraj wrote: > Interesting indeed... I didn't see a version number in your note, but I am > assuming that it is 8.1.7.x. We have also had some _very_ strange > occurrences of 'library cache lock' / 'library cache pin' problems - > sessions en-masse went into this state during high activity times on a > Solaris based 8.1.7.3 Apps 11i DB supporting about 300 users. [One would > have thought that lib cache pins/locks arose from voluntary/involuntary > compiles of stored proc/packages caused by Duhlevelopers changing code on > the sly]. We tightened up code changes, but this still occurred. We finally > traced it down to a bug - one of the sessions obtains a 'row cache lock' for > manipulating the dd cache for a specific table, and then 'hangs' and many > other session queue behind this one with lib cache pins/locks on that same > table. Oracle of course told us to upgrade to 8.1.7.4 - and we did after a > long round of testing. And this occurred again yesterday - and Oracle is > telling us to go 9.2.x as it was _really_ fixed in 9... Apparently this > occurs when either a MV refresh on that object takes place, or a combination > of TRUNCATEs (possibly on Partitioned tables) and INSERTs take place at the > same time, during heavy load. Both these situations were likely in our case. > > I think a ML search of certain keywords would generate a bug list of > sufficient size! > > John Kanagaraj > Oracle Applications DBA > DB Soft Inc > Work : (408) 970 7002 > > Listen to great, commercial-free christian music 24x7x365 at > http://www.klove.com > > ** The opinions and facts contained in this message are entirely mine > and do not reflect those of my employer or customers ** > > > >-----Original Message----- > >From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > >Sent: Thursday, July 31, 2003 4:59 PM > >To: Multiple recipients of list ORACLE-L > >Subject: Interesting Locking Problem > > > > > >List, > > > >Below is the description of a locking problem I ran into > >today. Any help > >to figure out what was happening here would be appreciated. Maybe > >I was overlooking something obvious, but I hope not. :) > > > >An MS Word version is available at: > > > >http://www.cybcon.com/~jkstill/CIM_enqueue_wait_2003_07_31.doc > > > >as it may be a little easier to read. > > > >---------------------- >... > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still 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).
