[Home] [Help] [Dependency Information]
Object Name: | USER_ADVISOR_SQLW_STMTS |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
WORKLOAD_ID | NUMBER | Yes | ||
WORKLOAD_NAME | VARCHAR2 | (128) | ||
SQL_ID | NUMBER | Yes | ||
HASH_VALUE | NUMBER | |||
USERNAME | VARCHAR2 | (128) | ||
MODULE | VARCHAR2 | (64) | ||
ACTION | VARCHAR2 | (64) | ||
CPU_TIME | NUMBER | |||
BUFFER_GETS | NUMBER | |||
DISK_READS | NUMBER | |||
ELAPSED_TIME | NUMBER | |||
ROWS_PROCESSED | NUMBER | |||
EXECUTIONS | NUMBER | |||
OPTIMIZER_COST | NUMBER | |||
LAST_EXECUTION_DATE | DATE | |||
PRIORITY | NUMBER | |||
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
, WORKLOAD_NAME
, SQL_ID
, HASH_VALUE
, USERNAME
, MODULE
, ACTION
, CPU_TIME
, BUFFER_GETS
, DISK_READS
, ELAPSED_TIME
, ROWS_PROCESSED
, EXECUTIONS
, OPTIMIZER_COST
, LAST_EXECUTION_DATE
, PRIORITY
, COMMAND_TYPE
, STAT_PERIOD
, SQL_TEXT
, VALID
FROM SYS.USER_ADVISOR_SQLW_STMTS;
|
|
|