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