Data Dictionary View
Columns ___________________________ ADDR LATCH# LEVEL# NAME GETS (successful willing to wait requests for a latch) MISSES (latch request failed) SLEEPS (how many times a willing to wait process slept) IMMEDIATE_GETS IMMEDIATE_MISSES WAITERS_WOKEN WAITS_HOLDING_LATCH SPIN_GETS (latch obtained after spinning once or more) SLEEP1 SLEEP2 SLEEP3 SLEEP4 SLEEP5 SLEEP6 SLEEP7 SLEEP8 SLEEP9 SLEEP10 SLEEP11 WAIT_TIME
Columns SLEEP5, SLEEP6,... SLEEP11 are present for compatibility with previous versions of Oracle. No data are accumulated for these columns.
Related:
V$BUFFER_POOL V$CACHE V$CLASS_PING V$DLM_LATCH V$ENQUEUE_LOCK V$EVENT_NAME V$LATCHHOLDER V$LATCHNAME V$LATCH_CHILDREN V$LATCH_MISSES V$LATCH_PARENT V$LIBRARYCACHE V$LOCK V$_LOCK V$LOCKED_OBJECT V$LOCKS_WITH_COLLISIONS V$LOCK_ACTIVITY V$LOCK_ELEMENT V$RESOURCE V$RESOURCE_LIMIT V$TRANSACTION_ENQUEUE