GV$SQL_PLAN

select
inst_id,                 -- INST_ID NUMBER
kqlfxpl_phad,            -- ADDRESS RAW(4)
kqlfxpl_hash,            -- HASH_VALUE NUMBER
kqlfxpl_sqlid,           -- SQL_ID VARCHAR2(13)
kqlfxpl_plhash,          -- PLAN_HASH_VALUE NUMBER
kqlfxpl_hadd,            -- CHILD_ADDRESS RAW(4)
kqlfxpl_chno,            -- CHILD_NUMBER NUMBER
kqlfxpl_timestamp,       -- TIMESTAMP DATE
substr                   -- OPERATION VARCHAR2(30)
  (kqlfxpl_oper, 1, 30),
substr                   -- OPTIONS VARCHAR2(30)
  (kqlfxpl_oopt, 1, 30),
substr                   -- OBJECT_NODE VARCHAR2(40)
  (kqlfxpl_tqid, 1, 40),
to_number                -- OBJECT# NUMBER
  (decode (kqlfxpl_objn, 0, NULL, kqlfxpl_objn)),
kqlfxpl_objowner,        -- OBJECT_OWNER VARCHAR2(30)
kqlfxpl_objname,         -- OBJECT_NAME VARCHAR2(30)
kqlfxpl_alias,           -- OBJECT_ALIAS VARCHAR2(65)
substr                   -- OBJECT_TYPE VARCHAR2(20)
  (kqlfxpl_objtype, 1, 20),
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
to_number                -- POSITION NUMBER
  (decode (kqlfxpl_pos, 0, decode (kqlfxpl_cost, 4294967295, NULL, kqlfxpl_cost), kqlfxpl_pos)),
kqlfxpl_scols,           -- SEARCH_COLUMNS NUMBER
to_number                -- COST NUMBER
  (decode (kqlfxpl_cost, 4294967295, 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, 4294967295, NULL, kqlfxpl_cpuc)),
to_number                -- IO_COST NUMBER
  (decode (kqlfxpl_ioct, 4294967295, 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)
kqlfxpl_proj,            -- PROJECTION VARCHAR2(4000)
to_number                -- TIME NUMBER
  (decode (kqlfxpl_time, 0, NULL, kqlfxpl_time)),
kqlfxpl_qblock,          -- QBLOCK_NAME VARCHAR2(30)
kqlfxpl_remark,          -- REMARKS VARCHAR2(4000)
kqlfxpl_other_xml        -- OTHER_XML CLOB
from
x$kqlfxpl p
home |  up  |  mailbox