GV$DLM_LATCH

select
USERENV ('Instance'),    -- INST_ID NUMBER
addr,                    -- ADDR RAW(4)
latch#,                  -- LATCH# NUMBER
level#,                  -- LEVEL# NUMBER
name,                    -- NAME VARCHAR2(50)
gets,                    -- GETS NUMBER
misses,                  -- MISSES NUMBER
sleeps,                  -- SLEEPS NUMBER
immediate_gets,          -- IMMEDIATE_GETS NUMBER
immediate_misses,        -- IMMEDIATE_MISSES NUMBER
waiters_woken,           -- WAITERS_WOKEN NUMBER
waits_holding_latch,     -- WAITS_HOLDING_LATCH NUMBER
spin_gets,               -- SPIN_GETS NUMBER
sleep1,                  -- SLEEP1 NUMBER
sleep2,                  -- SLEEP2 NUMBER
sleep3,                  -- SLEEP3 NUMBER
sleep4,                  -- SLEEP4 NUMBER
sleep5,                  -- SLEEP5 NUMBER
sleep6,                  -- SLEEP6 NUMBER
sleep7,                  -- SLEEP7 NUMBER
sleep8,                  -- SLEEP8 NUMBER
sleep9,                  -- SLEEP9 NUMBER
sleep10,                 -- SLEEP10 NUMBER
sleep11,                 -- SLEEP11 NUMBER
wait_time                -- WAIT_TIME NUMBER
from
V$LATCH 
where
NAME like 'ges %' or NAME like 'gcs %'
home |  up  |  mailbox