V$SQL_CS_SELECTIVITY definition in Oracle Database 11.2

V$SQL_CS_SELECTIVITY

select
  address,                                 -- ADDRESS RAW(8)
  hash_value,                              -- HASH_VALUE NUMBER
  sql_id,                                  -- SQL_ID VARCHAR2(13)
  child_number,                            -- CHILD_NUMBER NUMBER
  predicate,                               -- PREDICATE VARCHAR2(40)
  range_id,                                -- RANGE_ID NUMBER
  low,                                     -- LOW VARCHAR2(10)
  high                                     -- HIGH VARCHAR2(10)
from
  GV$SQL_CS_SELECTIVITY
where
  inst_id=USERENV('Instance')

home | up