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