DBPedias

All your database knowledge are belong to you

Oracle

Wait Event Descriptions - Wait Events - row cache lock

row cache lock

The session is trying to get a data dictionary lock. Wait Time:

In shared mode the foreground will wait 60 seconds for the LCK0 to get the lock, the foreground will wait in infinite loop until the lock has been granted (LCK0 will notify foreground). In exclusive mode the foreground will wait 3 seconds, in a loop of 1000 iterations. In either case PMON will wait for only 5 seconds.

Parameters

Parameter Description
cache id The CACHE# column value in the V$ROWCACHE view
cache id
select *
  from v$rowcache
 where cache# = cache id;
mode The mode the lock currently is held in.
request The mode the lock is requested in.
This event is used to wait for a lock on a data dictionary cache specified by "cache id". If one is running in shared mode (Parallel Server), the LCK0 is signalled to get the row cache lock for the foreground waiting on this event. The LCK0 process will get the lock asynchronously. In exclusive mode the foreground process will try to get the lock.