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. |