[Home] [Help] [Dependency Information]
Object Name: | WRI$_SQLSET_STATISTICS |
---|---|
Object Type: | TABLE |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Tablespace: | SYSAUX |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
WRI$_SQLSET_STATISTICS_PK | NORMAL | UNIQUE | SYSAUX |
STMT_ID
PLAN_HASH_VALUE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
STMT_ID | NUMBER | Yes | ||
PLAN_HASH_VALUE | NUMBER | Yes | ||
ELAPSED_TIME | NUMBER | |||
ELAPSED_TIME_DELTA | NUMBER | |||
CPU_TIME | NUMBER | |||
CPU_TIME_DELTA | NUMBER | |||
BUFFER_GETS | NUMBER | |||
BUFFER_GETS_DELTA | NUMBER | |||
DISK_READS | NUMBER | |||
DISK_READS_DELTA | NUMBER | |||
DIRECT_WRITES | NUMBER | |||
DIRECT_WRITES_DELTA | NUMBER | |||
ROWS_PROCESSED | NUMBER | |||
ROWS_PROCESSED_DELTA | NUMBER | |||
FETCHES | NUMBER | |||
FETCHES_DELTA | NUMBER | |||
EXECUTIONS | NUMBER | |||
EXECUTIONS_DELTA | NUMBER | |||
END_OF_FETCH_COUNT | NUMBER | |||
OPTIMIZER_COST | NUMBER | |||
FIRST_LOAD_TIME | VARCHAR2 | (19) | ||
FIRST_LOAD_TIME_DELTA | VARCHAR2 | (19) | ||
STAT_PERIOD | NUMBER | |||
ACTIVE_STAT_PERIOD | NUMBER | |||
CON_DBID | NUMBER | Yes |
Cut, paste (and edit) the following text to query this object:
SELECT STMT_ID
, PLAN_HASH_VALUE
, ELAPSED_TIME
, ELAPSED_TIME_DELTA
, CPU_TIME
, CPU_TIME_DELTA
, BUFFER_GETS
, BUFFER_GETS_DELTA
, DISK_READS
, DISK_READS_DELTA
, DIRECT_WRITES
, DIRECT_WRITES_DELTA
, ROWS_PROCESSED
, ROWS_PROCESSED_DELTA
, FETCHES
, FETCHES_DELTA
, EXECUTIONS
, EXECUTIONS_DELTA
, END_OF_FETCH_COUNT
, OPTIMIZER_COST
, FIRST_LOAD_TIME
, FIRST_LOAD_TIME_DELTA
, STAT_PERIOD
, ACTIVE_STAT_PERIOD
, CON_DBID
FROM SYS.WRI$_SQLSET_STATISTICS;
SYS.WRI$_SQLSET_STATISTICS does not reference any database object
SYS.WRI$_SQLSET_STATISTICS is referenced by following:
|
|
|