Re: UPDATE: RE: ERROR: WAITED TOO LONG FOR A ROW CACHE ENQUEUE LOCK! pid=30

2001-02-12 Thread Tom Pall
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

RE: ERROR: WAITED TOO LONG FOR A ROW CACHE ENQUEUE LOCK! pid=30

2001-02-12 Thread Steve Adams
Hi Glenn, I got one of these last night. The snapshot refresh process had an exclusive lock on the row cache enqueue for the snapshot and was waiting for a shared library cache lock on the base table. This is the WRONG locking order. Oracle is supposed to always take library cache locks before