DBA Data[Home] [Help]

VIEW: SYS.V_$WAITCLASSMETRIC_HISTORY

Source

View Text - Preformatted

select "BEGIN_TIME","END_TIME","INTSIZE_CSEC","WAIT_CLASS#","WAIT_CLASS_ID","AVERAGE_WAITER_COUNT","DBTIME_IN_WAIT","TIME_WAITED","WAIT_COUNT","TIME_WAITED_FG","WAIT_COUNT_FG","CON_ID" from v$waitclassmetric_history
View Text - HTML Formatted

SELECT "BEGIN_TIME"
, "END_TIME"
, "INTSIZE_CSEC"
, "WAIT_CLASS#"
, "WAIT_CLASS_ID"
, "AVERAGE_WAITER_COUNT"
, "DBTIME_IN_WAIT"
, "TIME_WAITED"
, "WAIT_COUNT"
, "TIME_WAITED_FG"
, "WAIT_COUNT_FG"
, "CON_ID"
FROM V$WAITCLASSMETRIC_HISTORY