Home Oracle Commands v$ Performance views
Oracle Data Dictionary

V$SQL_PLAN_STATISTICS_ALL

Data Dictionary View

Columns
   ___________________________
 
   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
   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
   ADDRESS
   HASH_VALUE
   CHILD_NUMBER
   OPERATION
   OPTIONS
   OBJECT_NODE
   OBJECT#
   OBJECT_OWNER
   OBJECT_NAME
   OPTIMIZER
   ID
   PARENT_ID

Related:



Simon Sheppard
SS64.com