GV$SQL_PLAN

select
inst_id,                 -- INST_ID NUMBER
kqlfxpl_phad,            -- ADDRESS RAW(4)
kqlfxpl_hash,            -- HASH_VALUE NUMBER
kqlfxpl_chno,            -- CHILD_NUMBER NUMBER
substr                   -- OPERATION VARCHAR2(30)
  (kqlfxpl_oper, 1, 30),
substr                   -- OPTIONS VARCHAR2(30)
  (kqlfxpl_oopt, 1, 30),
substr                   -- OBJECT_NODE VARCHAR2(10)
  (kqlfxpl_tqid, 1, 10),
to_number                -- OBJECT# NUMBER
  (decode (kqlfxpl_objn, 0, NULL, kqlfxpl_objn)),
case                     -- OBJECT_OWNER VARCHAR2(30)
  when kqlfxpl_objname is not null then 'SYS' else u.name end,
nvl                      -- OBJECT_NAME VARCHAR2(64)
  (p.kqlfxpl_objname, o.name),
substr                   -- OPTIMIZER VARCHAR2(20)
  (kqlfxpl_opti, 1, 20),
kqlfxpl_opid,            -- ID NUMBER
to_number                -- PARENT_ID NUMBER
  (decode (kqlfxpl_opid, 0, NULL, kqlfxpl_paid)),
kqlfxpl_depth,           -- DEPTH NUMBER
kqlfxpl_pos,             -- POSITION NUMBER
kqlfxpl_scols,           -- SEARCH_COLUMNS NUMBER
to_number                -- COST NUMBER
  (decode (kqlfxpl_cost, 0, NULL, kqlfxpl_cost)),
to_number                -- CARDINALITY NUMBER
  (decode (kqlfxpl_card, 0, NULL, kqlfxpl_card)),
to_number                -- BYTES NUMBER
  (decode (kqlfxpl_size, 0, NULL, kqlfxpl_size)),
substr                   -- OTHER_TAG VARCHAR2(35)
  (kqlfxpl_otag, 1, 35),
substr                   -- PARTITION_START VARCHAR2(5)
  (kqlfxpl_psta, 1, 5),
substr                   -- PARTITION_STOP VARCHAR2(5)
  (kqlfxpl_psto, 1, 5),
to_number                -- PARTITION_ID NUMBER
  (decode (kqlfxpl_pnid, 0, NULL, kqlfxpl_pnid)),
kqlfxpl_other,           -- OTHER VARCHAR2(4000)
substr                   -- DISTRIBUTION VARCHAR2(20)
  (kqlfxpl_dist, 1, 20),
to_number                -- CPU_COST NUMBER
  (decode (kqlfxpl_cpuc, 0, NULL, kqlfxpl_cpuc)),
to_number                -- IO_COST NUMBER
  (decode (kqlfxpl_ioct, 0, NULL, kqlfxpl_ioct)),
to_number                -- TEMP_SPACE NUMBER
  (decode (kqlfxpl_temp, 0, NULL, kqlfxpl_temp)),
kqlfxpl_keys,            -- ACCESS_PREDICATES VARCHAR2(4000)
kqlfxpl_filter           -- FILTER_PREDICATES VARCHAR2(4000)
from
x$kqlfxpl p,
obj$ o,
user$ u 
where
p.kqlfxpl_hadd != p.kqlfxpl_phad and p.kqlfxpl_objn = o.obj# (+) and o.owner# = u.user# (+)
home |  up  |  mailbox