[Home] [Help] [Dependency Information]
Object Name: | WRI$_ADV_SQLW_STMTS |
---|---|
Object Type: | TABLE |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Tablespace: | SYSAUX |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
SYS_IL0000363752C00018$$ | LOB | UNIQUE | SYSAUX | |
WRI$_ADV_SQLW_STMTS_PK | NORMAL | UNIQUE | SYSAUX |
WORKLOAD_ID
SQL_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
WORKLOAD_ID | NUMBER | Yes | ||
SQL_ID | NUMBER | Yes | ||
HASH_VALUE | NUMBER | |||
OPTIMIZER_COST | NUMBER | |||
USERNAME | VARCHAR2 | (128) | ||
MODULE | VARCHAR2 | (64) | ||
ACTION | VARCHAR2 | (64) | ||
ELAPSED_TIME | NUMBER | |||
CPU_TIME | NUMBER | |||
BUFFER_GETS | NUMBER | |||
DISK_READS | NUMBER | |||
ROWS_PROCESSED | NUMBER | |||
EXECUTIONS | NUMBER | |||
PRIORITY | NUMBER | |||
LAST_EXECUTION_DATE | DATE | |||
COMMAND_TYPE | NUMBER | |||
STAT_PERIOD | NUMBER | |||
SQL_TEXT | CLOB | (4000) | ||
VALID | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT WORKLOAD_ID
, SQL_ID
, HASH_VALUE
, OPTIMIZER_COST
, USERNAME
, MODULE
, ACTION
, ELAPSED_TIME
, CPU_TIME
, BUFFER_GETS
, DISK_READS
, ROWS_PROCESSED
, EXECUTIONS
, PRIORITY
, LAST_EXECUTION_DATE
, COMMAND_TYPE
, STAT_PERIOD
, SQL_TEXT
, VALID
FROM SYS.WRI$_ADV_SQLW_STMTS;
SYS.WRI$_ADV_SQLW_STMTS does not reference any database object
SYS.WRI$_ADV_SQLW_STMTS is referenced by following:
|
|
|