V$SQL_CS_HISTOGRAM definition in Oracle Database 11.2

V$SQL_CS_HISTOGRAM

select
  address,                                 -- ADDRESS RAW(8)
  hash_value,                              -- HASH_VALUE NUMBER
  sql_id,                                  -- SQL_ID VARCHAR2(13)
  child_number,                            -- CHILD_NUMBER NUMBER
  bucket_id,                               -- BUCKET_ID NUMBER
  count                                    -- COUNT NUMBER
from
  GV$SQL_CS_HISTOGRAM
where
  inst_id=USERENV('Instance')

home | up