V$SQL_PLAN_STATISTICS definition in Oracle Database 11.2
V$SQL_PLAN_STATISTICS

select
  ADDRESS,                                 -- ADDRESS RAW(8)
  HASH_VALUE,                              -- HASH_VALUE NUMBER
  SQL_ID,                                  -- SQL_ID VARCHAR2(13)
  PLAN_HASH_VALUE,                         -- PLAN_HASH_VALUE NUMBER
  CHILD_ADDRESS,                           -- CHILD_ADDRESS RAW(8)
  CHILD_NUMBER,                            -- CHILD_NUMBER NUMBER
  OPERATION_ID,                            -- OPERATION_ID NUMBER
  EXECUTIONS,                              -- EXECUTIONS NUMBER
  LAST_STARTS,                             -- LAST_STARTS NUMBER
  STARTS,                                  -- STARTS NUMBER
  LAST_OUTPUT_ROWS,                        -- LAST_OUTPUT_ROWS NUMBER
  OUTPUT_ROWS,                             -- OUTPUT_ROWS NUMBER
  LAST_CR_BUFFER_GETS,                     -- LAST_CR_BUFFER_GETS NUMBER
  CR_BUFFER_GETS,                          -- CR_BUFFER_GETS NUMBER
  LAST_CU_BUFFER_GETS,                     -- LAST_CU_BUFFER_GETS NUMBER
  CU_BUFFER_GETS,                          -- CU_BUFFER_GETS NUMBER
  LAST_DISK_READS,                         -- LAST_DISK_READS NUMBER
  DISK_READS,                              -- DISK_READS NUMBER
  LAST_DISK_WRITES,                        -- LAST_DISK_WRITES NUMBER
  DISK_WRITES,                             -- DISK_WRITES NUMBER
  LAST_ELAPSED_TIME,                       -- LAST_ELAPSED_TIME NUMBER
  ELAPSED_TIME                             -- ELAPSED_TIME NUMBER
from
  GV$SQL_PLAN_STATISTICS
where
  inst_id = USERENV('Instance')

home |  up