DBA Data[Home] [Help]

VIEW: SYS.GV_$ENQUEUE_STATISTICS

Source

View Text - Preformatted

select "INST_ID","EQ_NAME","EQ_TYPE","REQ_REASON","TOTAL_REQ#","TOTAL_WAIT#","SUCC_REQ#","FAILED_REQ#","CUM_WAIT_TIME","REQ_DESCRIPTION","EVENT#","CON_ID" from gv$enqueue_statistics
View Text - HTML Formatted

SELECT "INST_ID"
, "EQ_NAME"
, "EQ_TYPE"
, "REQ_REASON"
, "TOTAL_REQ#"
, "TOTAL_WAIT#"
, "SUCC_REQ#"
, "FAILED_REQ#"
, "CUM_WAIT_TIME"
, "REQ_DESCRIPTION"
, "EVENT#"
, "CON_ID"
FROM GV$ENQUEUE_STATISTICS