V$LATCH

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 


© Copyright SS64.com 1999-2013
Some rights reserved