VIEW: SYS.CDB_ADVISOR_SQLPLANS

Source

View Text - Preformatted

SELECT "TASK_NAME","TASK_ID","EXECUTION_NAME","SQL_ID","OBJECT_ID","ATTRIBUTE","STATEMENT_ID","PLAN_HASH_VALUE","PLAN_ID","TIMESTAMP","REMARKS","OPERATION","OPTIONS","OBJECT_NODE","OBJECT_OWNER","OBJECT_NAME","OBJECT_ALIAS","OBJECT_INSTANCE","OBJECT_TYPE","OPTIMIZER","SEARCH_COLUMNS","ID","PARENT_ID","DEPTH","POSITION","COST","CARDINALITY","BYTES","OTHER_TAG","PARTITION_START","PARTITION_STOP","PARTITION_ID","DISTRIBUTION","CPU_COST","IO_COST","TEMP_SPACE","ACCESS_PREDICATES","FILTER_PREDICATES","PROJECTION","TIME","QBLOCK_NAME","OTHER_XML","CON_ID" FROM CONTAINERS("SYS"."DBA_ADVISOR_SQLPLANS")

View Text - HTML Formatted

SELECT "TASK_NAME"
, "TASK_ID"
, "EXECUTION_NAME"
, "SQL_ID"
, "OBJECT_ID"
, "ATTRIBUTE"
, "STATEMENT_ID"
, "PLAN_HASH_VALUE"
, "PLAN_ID"
, "TIMESTAMP"
, "REMARKS"
, "OPERATION"
, "OPTIONS"
, "OBJECT_NODE"
, "OBJECT_OWNER"
, "OBJECT_NAME"
, "OBJECT_ALIAS"
, "OBJECT_INSTANCE"
, "OBJECT_TYPE"
, "OPTIMIZER"
, "SEARCH_COLUMNS"
, "ID"
, "PARENT_ID"
, "DEPTH"
, "POSITION"
, "COST"
, "CARDINALITY"
, "BYTES"
, "OTHER_TAG"
, "PARTITION_START"
, "PARTITION_STOP"
, "PARTITION_ID"
, "DISTRIBUTION"
, "CPU_COST"
, "IO_COST"
, "TEMP_SPACE"
, "ACCESS_PREDICATES"
, "FILTER_PREDICATES"
, "PROJECTION"
, "TIME"
, "QBLOCK_NAME"
, "OTHER_XML"
, "CON_ID"
FROM CONTAINERS("SYS"."DBA_ADVISOR_SQLPLANS")