VIEW: SYS.CDB_SQLSET_PLANS

Source

View Text - Preformatted

SELECT "SQLSET_NAME","SQLSET_OWNER","SQLSET_ID","CON_DBID","SQL_ID","FORCE_MATCHING_SIGNATURE","PLAN_HASH_VALUE","SQL_SEQ","STATEMENT_ID","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","EXECUTIONS","STARTS","OUTPUT_ROWS","CR_BUFFER_GETS","CU_BUFFER_GETS","DISK_READS","DISK_WRITES","ELAPSED_TIME","LAST_STARTS","LAST_OUTPUT_ROWS","LAST_CR_BUFFER_GETS","LAST_CU_BUFFER_GETS","LAST_DISK_READS","LAST_DISK_WRITES","LAST_ELAPSED_TIME","POLICY","ESTIMATED_OPTIMAL_SIZE","ESTIMATED_ONEPASS_SIZE","LAST_MEMORY_USED","LAST_EXECUTION","LAST_DEGREE","TOTAL_EXECUTIONS","OPTIMAL_EXECUTIONS","ONEPASS_EXECUTIONS","MULTIPASSES_EXECUTIONS","ACTIVE_TIME","MAX_TEMPSEG_SIZE","LAST_TEMPSEG_SIZE","CON_ID" FROM CONTAINERS("SYS"."DBA_SQLSET_PLANS")

View Text - HTML Formatted

SELECT "SQLSET_NAME"
, "SQLSET_OWNER"
, "SQLSET_ID"
, "CON_DBID"
, "SQL_ID"
, "FORCE_MATCHING_SIGNATURE"
, "PLAN_HASH_VALUE"
, "SQL_SEQ"
, "STATEMENT_ID"
, "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"
, "EXECUTIONS"
, "STARTS"
, "OUTPUT_ROWS"
, "CR_BUFFER_GETS"
, "CU_BUFFER_GETS"
, "DISK_READS"
, "DISK_WRITES"
, "ELAPSED_TIME"
, "LAST_STARTS"
, "LAST_OUTPUT_ROWS"
, "LAST_CR_BUFFER_GETS"
, "LAST_CU_BUFFER_GETS"
, "LAST_DISK_READS"
, "LAST_DISK_WRITES"
, "LAST_ELAPSED_TIME"
, "POLICY"
, "ESTIMATED_OPTIMAL_SIZE"
, "ESTIMATED_ONEPASS_SIZE"
, "LAST_MEMORY_USED"
, "LAST_EXECUTION"
, "LAST_DEGREE"
, "TOTAL_EXECUTIONS"
, "OPTIMAL_EXECUTIONS"
, "ONEPASS_EXECUTIONS"
, "MULTIPASSES_EXECUTIONS"
, "ACTIVE_TIME"
, "MAX_TEMPSEG_SIZE"
, "LAST_TEMPSEG_SIZE"
, "CON_ID"
FROM CONTAINERS("SYS"."DBA_SQLSET_PLANS")