DBA Data[Home] [Help] [Dependency Information]

VIEW: SYS.CDB_ADVISOR_SQLA_WK_STMTS

Object Details
Object Name: CDB_ADVISOR_SQLA_WK_STMTS
Object Type: VIEW
Owner: SYS
Subobject Name:
Status: VALID

in all containers

[View Source]

Columns
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

CON_ID NUMBER

container id
Query Text

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
,      CON_ID
FROM SYS.CDB_ADVISOR_SQLA_WK_STMTS;

Dependencies

[top of page]

SYS.CDB_ADVISOR_SQLA_WK_STMTS does not reference any database object

SYS.CDB_ADVISOR_SQLA_WK_STMTS is referenced by following:

SchemaPUBLIC
SynonymCDB_ADVISOR_SQLA_WK_STMTS