V$MUTEX_SLEEP_HISTORY definition in Oracle Database 11.2
V$MUTEX_SLEEP_HISTORY

select
  MUTEX_IDENTIFIER,                        -- MUTEX_IDENTIFIER 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(8)
  P1,                                      -- P1 NUMBER
  P1RAW,                                   -- P1RAW RAW(8)
  P2,                                      -- P2 NUMBER
  P3,                                      -- P3 NUMBER
  P4,                                      -- P4 NUMBER
  P5                                       -- P5 VARCHAR2(64)
from
  GV$MUTEX_SLEEP_HISTORY
where
  INST_ID = USERENV('INSTANCE')

home |  up