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

From: Fowler, Kenneth R <kenneth_r_fowler_at_groton.pfizer.com>
Date: Mon, 12 Feb 2001 11:04:07 -0800
Message-ID: <F001.002B1E0B.20010212110606@fatcity.com>

What platform and oracle version are you on???

We had a similar problem where I work on a server running Solaris 2.6 and oracle 8.1.6.2.

We were getting the same error "WAITED TOO LONG FOR A ROW CACHE ENQUEUE LOCK..." and the problem seemed to be caused by a fast refresh snapshot. The snapshot was on a large high activity table. The snapshot refreshed "fast refresh" each 10 min via rowid. Even though we do have oracle support it was too little too late and we eventually had to change the snapshots to full refresh daily to avoid the lockups that were occurring.

The server in question is an Ultra-4 with 4 CPU's and 4 Gig of physical memory. Another symptom that I noticed is that the snapshot log was not being truncated as it should and would continue to grow and grow.

Any of this sound familiar? I would be interested in hearing about any resolution you find.

Ken.

-----Original Message-----
Sent: Monday, February 12, 2001 11:16 AM To: Multiple recipients of list ORACLE-L

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.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Glenn Travis
  INET: Glenn.Travis_at_wcom.com

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: ListGuru_at_fatcity.com (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: Fowler, Kenneth R
  INET: kenneth_r_fowler_at_groton.pfizer.com

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: ListGuru_at_fatcity.com (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).

Received on Mon Feb 12 2001 - 13:04:07 CST