GV$SQL_CS_HISTOGRAM definition in Oracle Database 11.2
GV$SQL_CS_HISTOGRAM

select
  inst_id,                                 -- INST_ID NUMBER
  phadd_kkocs,                             -- ADDRESS RAW(8)
  hashv_kkocs,                             -- HASH_VALUE NUMBER
  sqlid_kkocs,                             -- SQL_ID VARCHAR2(13)
  childno_kkocs,                           -- CHILD_NUMBER NUMBER
  bucketid_kkocs,                          -- BUCKET_ID NUMBER
  count_kkocs                              -- COUNT NUMBER
from
  X$KKOCS_HISTOGRAM

home |  up