V$SQL_CS_STATISTICS definition in Oracle Database 11.2

V$SQL_CS_STATISTICS

select
  address,                                 -- ADDRESS RAW(8)
  hash_value,                              -- HASH_VALUE NUMBER
  sql_id,                                  -- SQL_ID VARCHAR2(13)
  child_number,                            -- CHILD_NUMBER NUMBER
  bind_set_hash_value,                     -- BIND_SET_HASH_VALUE NUMBER
  peeked,                                  -- PEEKED VARCHAR2(1)
  executions,                              -- EXECUTIONS NUMBER
  rows_processed,                          -- ROWS_PROCESSED NUMBER
  buffer_gets,                             -- BUFFER_GETS NUMBER
  cpu_time                                 -- CPU_TIME NUMBER
from
  GV$SQL_CS_STATISTICS
where
  inst_id=USERENV('Instance')

home | up