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