[Home] [Help] [Dependency Information]
Object Name: | DBA_ADVISOR_SQLA_WK_STMTS |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
OWNER | VARCHAR2 | (128) | ||
TASK_NAME | VARCHAR2 | (128) | ||
TASK_ID | NUMBER | Yes | ||
SQLSET_ID | NUMBER | |||
SQLSET_NAME | VARCHAR2 | (128) | ||
WORKLOAD_NAME | VARCHAR2 | (128) | ||
SQL_ID | VARCHAR2 | (13) | Yes | |
SQL_SEQ | NUMBER | Yes | ||
PLAN_HASH_VALUE | NUMBER | Yes | ||
PARSING_SCHEMA_NAME | VARCHAR2 | (128) | ||
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 | |||
FIRST_LOAD_TIME | DATE | |||
LAST_EXECUTION_DATE | DATE | |||
PRIORITY | NUMBER | |||
COMMAND_TYPE | NUMBER | |||
STAT_PERIOD | NUMBER | |||
ACTIVE_STAT_PERIOD | NUMBER | |||
SQL_TEXT | CLOB | (4000) | ||
PRECOST | NUMBER | |||
POSTCOST | NUMBER | |||
IMPORTANCE | NUMBER | |||
REC_ID | NUMBER | |||
VALIDATED | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT OWNER
, TASK_NAME
, TASK_ID
, SQLSET_ID
, SQLSET_NAME
, WORKLOAD_NAME
, SQL_ID
, SQL_SEQ
, PLAN_HASH_VALUE
, PARSING_SCHEMA_NAME
, USERNAME
, MODULE
, ACTION
, CPU_TIME
, BUFFER_GETS
, DISK_READS
, ELAPSED_TIME
, ROWS_PROCESSED
, EXECUTIONS
, FIRST_LOAD_TIME
, LAST_EXECUTION_DATE
, PRIORITY
, COMMAND_TYPE
, STAT_PERIOD
, ACTIVE_STAT_PERIOD
, SQL_TEXT
, PRECOST
, POSTCOST
, IMPORTANCE
, REC_ID
, VALIDATED
FROM SYS.DBA_ADVISOR_SQLA_WK_STMTS;
|
|
|