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).