DBA Data[Home] [Help]

VIEW: SYS.GV_$MUTEX_SLEEP_HISTORY

Source

View Text - Preformatted

select "INST_ID","MUTEX_IDENTIFIER","SLEEP_TIMESTAMP","MUTEX_TYPE","GETS","SLEEPS","REQUESTING_SESSION","BLOCKING_SESSION","LOCATION","MUTEX_VALUE","P1","P1RAW","P2","P3","P4","P5","CON_ID" from gv$mutex_sleep_history
View Text - HTML Formatted

SELECT "INST_ID"
, "MUTEX_IDENTIFIER"
, "SLEEP_TIMESTAMP"
, "MUTEX_TYPE"
, "GETS"
, "SLEEPS"
, "REQUESTING_SESSION"
, "BLOCKING_SESSION"
, "LOCATION"
, "MUTEX_VALUE"
, "P1"
, "P1RAW"
, "P2"
, "P3"
, "P4"
, "P5"
, "CON_ID"
FROM GV$MUTEX_SLEEP_HISTORY