select
lt.inst_id, -- INST_ID NUMBER
lt.kslltaddr, -- ADDR RAW(8)
lt.kslltnum, -- LATCH# NUMBER
lt.kslltlvl, -- LEVEL# NUMBER
lt.kslltnam, -- NAME VARCHAR2(64)
lt.ksllthsh, -- HASH NUMBER
lt.kslltwgt, -- GETS NUMBER
lt.kslltwff, -- MISSES NUMBER
lt.kslltwsl, -- SLEEPS NUMBER
lt.kslltngt, -- IMMEDIATE_GETS NUMBER
lt.kslltnfa, -- IMMEDIATE_MISSES NUMBER
lt.kslltwkc, -- WAITERS_WOKEN NUMBER
lt.kslltwth, -- WAITS_HOLDING_LATCH NUMBER
lt.ksllthst0, -- SPIN_GETS NUMBER
lt.ksllthst1, -- SLEEP1 NUMBER
lt.ksllthst2, -- SLEEP2 NUMBER
lt.ksllthst3, -- SLEEP3 NUMBER
lt.ksllthst4, -- SLEEP4 NUMBER
lt.ksllthst5, -- SLEEP5 NUMBER
lt.ksllthst6, -- SLEEP6 NUMBER
lt.ksllthst7, -- SLEEP7 NUMBER
lt.ksllthst8, -- SLEEP8 NUMBER
lt.ksllthst9, -- SLEEP9 NUMBER
lt.ksllthst10, -- SLEEP10 NUMBER
lt.ksllthst11, -- SLEEP11 NUMBER
lt.kslltwtt -- WAIT_TIME NUMBER
from
x$kslltr lt