waited too long for row cache enqueue lock 
Author Message
 waited too long for row cache enqueue lock

I have/had a site that occasionally locks up and is core dumping with
the 'waited too long for row cache enqueue lock'. (they had to shutdown
abort in 7.1.4) and so far have been unable to find out (thru books and
some interface with Oracle corp )that, IF it's a parameter problem, what
to make bigger. Yesterday I suggested they increase database block
buffers by 20% (to 10,000), and enqueue resources from 1220 to 1720.
Redo logs weren't switching over (presumably because they weren't doing
anything).  utllockt wouldn't run/finish.  We couldn't even look at
almost anything in the database because queries, etc would not finish.
The machine has more memory than we are currently using and the SGA is
about 140M. Solaris 2.3. There were 'a lot' of users logged on and the
appls typically reference a lot of tables, I understand. (definitely not
an OLTP system)
Would appreciate any ideas of what I should be looking for or where to
go for more info. I have looked at Oracle Press's backup and recovery,
Oracle's DBA book (7) and the Orange Tuning book (not an Oracle press
book)
thanks
Joan



Mon, 09 Oct 2000 03:00:00 GMT
 waited too long for row cache enqueue lock

There are a number of bugs (especially at 7.1.4) that could be
causing
this to happen.  It isn't necessarily any tuning parameter.

For example, if you try to create a unique index on a table in one
session
and simultaneously analyze the table from another table you can get
a deadlock of this type irrespective of the resources available.

However, you might try increasing the library cache (by increasing
the
shared pool) since some of the problems are caused by over active
systems with library cache and row cache flushing occurring too
rapidly.



Mon, 09 Oct 2000 03:00:00 GMT
 
 [ 3 post ] 

 Relevant Pages 

1. Waited Too Long For Row Cache Enqueue Lock

2. library cache lock | transaction enqueue lock

3. SMON Having lock on temporary segment (enqueue lock)

4. enqueue waits

5. enqueue wait event

6. No Wait for Update of locked row?

7. DBMS_AQ.Enqueue gives incorrect enqueue time

8. Row cache lock tuning

9. transaction enqueue lock

10. Problem with enqueue locks

11. system waits for "library cache pin"

12. Library cache pin Wait


 
Powered by phpBB® Forum Software