VIEW: SYS.CDB_ADVISOR_SQLW_STMTS

Source

View Text - Preformatted

SELECT "OWNER","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","CON_ID" FROM CONTAINERS("SYS"."DBA_ADVISOR_SQLW_STMTS")

View Text - HTML Formatted

SELECT "OWNER"
, "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"
, "CON_ID"
FROM CONTAINERS("SYS"."DBA_ADVISOR_SQLW_STMTS")