GV$MUTEX_SLEEP_HISTORY

select
INST_ID,                 -- INST_ID NUMBER
SLEEP_TIMESTAMP,         -- SLEEP_TIMESTAMP TIMESTAMP(6)
MUTEX_TYPE,              -- MUTEX_TYPE VARCHAR2(32)
GETS,                    -- GETS NUMBER
SLEEPS,                  -- SLEEPS NUMBER
REQUESTING_SESSION,      -- REQUESTING_SESSION NUMBER
BLOCKING_SESSION,        -- BLOCKING_SESSION NUMBER
LOCATION,                -- LOCATION VARCHAR2(40)
MUTEX_VALUE,             -- MUTEX_VALUE RAW(4)
P1,                      -- P1 NUMBER
P1RAW,                   -- P1RAW RAW(4)
P2,                      -- P2 NUMBER
P3,                      -- P3 NUMBER
P4,                      -- P4 NUMBER
P5                       -- P5 VARCHAR2(64)
from
x$MUTEX_SLEEP_HISTORY
home |  up  |  mailbox