DBA Data[Home] [Help]

VIEW: SYS.V_$SYS_REPORT_STATS

Source

View Text - Preformatted

select "CON_ID","EXECUTION_MODE","NUM_QUEUED_REQUESTS","NUM_FAILED_REQUESTS","NUM_FAILED_CYCLES","LAST_FAILED_CYCLE_TIME","CYCLES_SINCE_STATS_RESET","LAST_CYCLE_TIME","LAST_STATS_RESET_TIME","LAST_PURGE_TIME","AVAILABLE_DBTIME","AVG_DB_TIME","AVG_CPU_TIME","AVG_USERIO_TIME","DB_TIME","CPU_TIME","USERIO_TIME" from v$sys_report_stats
View Text - HTML Formatted

SELECT "CON_ID"
, "EXECUTION_MODE"
, "NUM_QUEUED_REQUESTS"
, "NUM_FAILED_REQUESTS"
, "NUM_FAILED_CYCLES"
, "LAST_FAILED_CYCLE_TIME"
, "CYCLES_SINCE_STATS_RESET"
, "LAST_CYCLE_TIME"
, "LAST_STATS_RESET_TIME"
, "LAST_PURGE_TIME"
, "AVAILABLE_DBTIME"
, "AVG_DB_TIME"
, "AVG_CPU_TIME"
, "AVG_USERIO_TIME"
, "DB_TIME"
, "CPU_TIME"
, "USERIO_TIME"
FROM V$SYS_REPORT_STATS