VIEW: SYS.CDB_HIST_SQL_PLAN

Source

View Text - Preformatted

SELECT "DBID","SQL_ID","PLAN_HASH_VALUE","ID","OPERATION","OPTIONS","OBJECT_NODE","OBJECT#","OBJECT_OWNER","OBJECT_NAME","OBJECT_ALIAS","OBJECT_TYPE","OPTIMIZER","PARENT_ID","DEPTH","POSITION","SEARCH_COLUMNS","COST","CARDINALITY","BYTES","OTHER_TAG","PARTITION_START","PARTITION_STOP","PARTITION_ID","OTHER","DISTRIBUTION","CPU_COST","IO_COST","TEMP_SPACE","ACCESS_PREDICATES","FILTER_PREDICATES","PROJECTION","TIME","QBLOCK_NAME","REMARKS","TIMESTAMP","OTHER_XML","CON_DBID","CON_ID" FROM CONTAINERS("SYS"."DBA_HIST_SQL_PLAN")

View Text - HTML Formatted

SELECT "DBID"
, "SQL_ID"
, "PLAN_HASH_VALUE"
, "ID"
, "OPERATION"
, "OPTIONS"
, "OBJECT_NODE"
, "OBJECT#"
, "OBJECT_OWNER"
, "OBJECT_NAME"
, "OBJECT_ALIAS"
, "OBJECT_TYPE"
, "OPTIMIZER"
, "PARENT_ID"
, "DEPTH"
, "POSITION"
, "SEARCH_COLUMNS"
, "COST"
, "CARDINALITY"
, "BYTES"
, "OTHER_TAG"
, "PARTITION_START"
, "PARTITION_STOP"
, "PARTITION_ID"
, "OTHER"
, "DISTRIBUTION"
, "CPU_COST"
, "IO_COST"
, "TEMP_SPACE"
, "ACCESS_PREDICATES"
, "FILTER_PREDICATES"
, "PROJECTION"
, "TIME"
, "QBLOCK_NAME"
, "REMARKS"
, "TIMESTAMP"
, "OTHER_XML"
, "CON_DBID"
, "CON_ID"
FROM CONTAINERS("SYS"."DBA_HIST_SQL_PLAN")