VIEW: SYS.GV_$SQL_PLAN_STATISTICS_ALL

Source

View Text - Preformatted

select "INST_ID","ADDRESS","HASH_VALUE","SQL_ID","PLAN_HASH_VALUE","FULL_PLAN_HASH_VALUE","CHILD_ADDRESS","CHILD_NUMBER","TIMESTAMP","OPERATION","OPTIONS","OBJECT_NODE","OBJECT#","OBJECT_OWNER","OBJECT_NAME","OBJECT_ALIAS","OBJECT_TYPE","OPTIMIZER","ID","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","OTHER_XML","EXECUTIONS","LAST_STARTS","STARTS","LAST_OUTPUT_ROWS","OUTPUT_ROWS","LAST_CR_BUFFER_GETS","CR_BUFFER_GETS","LAST_CU_BUFFER_GETS","CU_BUFFER_GETS","LAST_DISK_READS","DISK_READS","LAST_DISK_WRITES","DISK_WRITES","LAST_ELAPSED_TIME","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","CON_DBID" from gv$sql_plan_statistics_all

View Text - HTML Formatted

SELECT "INST_ID"
, "ADDRESS"
, "HASH_VALUE"
, "SQL_ID"
, "PLAN_HASH_VALUE"
, "FULL_PLAN_HASH_VALUE"
, "CHILD_ADDRESS"
, "CHILD_NUMBER"
, "TIMESTAMP"
, "OPERATION"
, "OPTIONS"
, "OBJECT_NODE"
, "OBJECT#"
, "OBJECT_OWNER"
, "OBJECT_NAME"
, "OBJECT_ALIAS"
, "OBJECT_TYPE"
, "OPTIMIZER"
, "ID"
, "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"
, "OTHER_XML"
, "EXECUTIONS"
, "LAST_STARTS"
, "STARTS"
, "LAST_OUTPUT_ROWS"
, "OUTPUT_ROWS"
, "LAST_CR_BUFFER_GETS"
, "CR_BUFFER_GETS"
, "LAST_CU_BUFFER_GETS"
, "CU_BUFFER_GETS"
, "LAST_DISK_READS"
, "DISK_READS"
, "LAST_DISK_WRITES"
, "DISK_WRITES"
, "LAST_ELAPSED_TIME"
, "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"
, "CON_DBID"
FROM GV$SQL_PLAN_STATISTICS_ALL