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

We have had a problem with hangs in 8.1.6. The symptom we see is an extremely high version_count value in many of the rows of the v$sqlarea table at the time of the hang. v$session_waits also has many sessions waiting on pins of the shared pool. Basically, in our case, the shared pool was full of sql that should have been sharable. I am not sure if this is the same problem, but it sounds similar. Try doing a search in MetaLink on timed_statistics and/or sqlexec_progression_cost if you think this could be your problem.

> -----Original Message-----
> From: Glenn Travis [SMTP:Glenn.Travis_at_wcom.com]
> Sent: Monday, February 12, 2001 10:16 AM
> To: Multiple recipients of list ORACLE-L
> 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.
>
> --
> 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: Elliott, Patrick
  INET: Patrick.Elliott_at_bestbuy.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).