[Home] [Help] [Dependency Information]
Object Name: | V_$SYS_REPORT_STATS |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CON_ID | NUMBER | |||
EXECUTION_MODE | VARCHAR2 | (12) | ||
NUM_QUEUED_REQUESTS | NUMBER | |||
NUM_FAILED_REQUESTS | NUMBER | |||
NUM_FAILED_CYCLES | NUMBER | |||
LAST_FAILED_CYCLE_TIME | DATE | |||
CYCLES_SINCE_STATS_RESET | NUMBER | |||
LAST_CYCLE_TIME | DATE | |||
LAST_STATS_RESET_TIME | DATE | |||
LAST_PURGE_TIME | DATE | |||
AVAILABLE_DBTIME | NUMBER | |||
AVG_DB_TIME | NUMBER | |||
AVG_CPU_TIME | NUMBER | |||
AVG_USERIO_TIME | NUMBER | |||
DB_TIME | NUMBER | |||
CPU_TIME | NUMBER | |||
USERIO_TIME | NUMBER |
Cut, paste (and edit) the following text to query this object:
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 SYS.V_$SYS_REPORT_STATS;
|
|
|