GV$SQL_PLAN definition in Oracle Database 11.2
GV$SQL_PLAN

select
  inst_id,                                 -- INST_ID NUMBER
  kqlfxpl_phad,                            -- ADDRESS RAW(8)
  kqlfxpl_hash,                            -- HASH_VALUE NUMBER
  kqlfxpl_sqlid,                           -- SQL_ID VARCHAR2(13)
  kqlfxpl_plhash,                          -- PLAN_HASH_VALUE NUMBER
  kqlfxpl_hadd,                            -- CHILD_ADDRESS RAW(8)
  kqlfxpl_chno,                            -- CHILD_NUMBER NUMBER
  kqlfxpl_timestamp,                       -- TIMESTAMP DATE
  substr(kqlfxpl_oper, 1, 30),             -- OPERATION VARCHAR2(30)
  substr(kqlfxpl_oopt, 1, 30),             -- OPTIONS VARCHAR2(30)
  substr(kqlfxpl_tqid, 1, 40),             -- OBJECT_NODE VARCHAR2(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(kqlfxpl_objtype, 1, 20),          -- OBJECT_TYPE VARCHAR2(20)
  substr(kqlfxpl_opti, 1, 20),             -- OPTIMIZER VARCHAR2(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(kqlfxpl_otag, 1, 35),             -- OTHER_TAG VARCHAR2(35)
  substr(kqlfxpl_psta, 1, 64),             -- PARTITION_START VARCHAR2(64)
  substr(kqlfxpl_psto, 1, 64),             -- PARTITION_STOP VARCHAR2(64)
  to_number(                               -- PARTITION_ID NUMBER
    decode(kqlfxpl_pnid, 0, NULL, kqlfxpl_pnid)),
  kqlfxpl_other,                           -- OTHER VARCHAR2(4000)
  substr(kqlfxpl_dist, 1, 20),             -- DISTRIBUTION VARCHAR2(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