GV$SQLAREA_PLAN_HASH

select
inst_id,                 -- INST_ID NUMBER
kglnaobj,                -- SQL_TEXT VARCHAR2(1000)
kglfnobj,                -- SQL_FULLTEXT CLOB
kglhdpar,                -- ADDRESS RAW(4)
kglobt46,                -- HASH_VALUE NUMBER
kglobt03,                -- SQL_ID VARCHAR2(13)
kglobt30,                -- PLAN_HASH_VALUE NUMBER
kglobccc,                -- VERSION_COUNT NUMBER
kglhdadr,                -- LAST_ACTIVE_CHILD_ADDRESS RAW(4)
kglobhs0+kglobhs1+kglobhs2+kglobhs3+kglobhs4+kglobhs5+kglobhs6, -- SHARABLE_MEM NUMBER
kglobt08+kglobt11,       -- PERSISTENT_MEM NUMBER
kglobt10,                -- RUNTIME_MEM NUMBER
kglobt01,                -- SORTS NUMBER
kglobclc,                -- LOADED_VERSIONS NUMBER
kglhdlmd,                -- OPEN_VERSIONS NUMBER
kglhdlkc,                -- USERS_OPENING NUMBER
kglobpc6,                -- USERS_EXECUTING NUMBER
kglobt04,                -- FETCHES NUMBER
kglobt05,                -- EXECUTIONS NUMBER
kglobt50,                -- PX_SERVERS_EXECUTIONS NUMBER
kglobt35,                -- END_OF_FETCH_COUNT NUMBER
kglhdldc,                -- LOADS NUMBER
kglnatim,                -- FIRST_LOAD_TIME DATE
kglobtt0,                -- LAST_LOAD_TIME DATE
kglobcla,                -- LAST_ACTIVE_TIME DATE
kglhdivc,                -- INVALIDATIONS NUMBER
kglobt12,                -- PARSE_CALLS NUMBER
kglobt13,                -- DISK_READS NUMBER
kglobwdw,                -- DIRECT_WRITES NUMBER
kglobt14,                -- BUFFER_GETS NUMBER
kglobt06,                -- CPU_TIME NUMBER
kglobt07,                -- ELAPSED_TIME NUMBER
kglobwap,                -- APPLICATION_WAIT_TIME NUMBER
kglobwcc,                -- CONCURRENCY_WAIT_TIME NUMBER
kglobwcl,                -- CLUSTER_WAIT_TIME NUMBER
kglobwui,                -- USER_IO_WAIT_TIME NUMBER
kglobt42,                -- PLSQL_EXEC_TIME NUMBER
kglobt43,                -- JAVA_EXEC_TIME NUMBER
kglobt15,                -- ROWS_PROCESSED NUMBER
kglobt02,                -- COMMAND_TYPE NUMBER
decode                   -- OPTIMIZER_MODE VARCHAR2(10)
  (kglobt32, 0, 'NONE', 1, 'ALL_ROWS', 2, 'FIRST_ROWS', 3, 'RULE', 4, 'CHOOSE', 'UNKNOWN'),
kglobtn0,                -- OPTIMIZER_COST NUMBER
kglobcce,                -- OPTIMIZER_ENV RAW(797)
kglobcceh,               -- OPTIMIZER_ENV_HASH_VALUE NUMBER
kglobt17,                -- PARSING_USER_ID NUMBER
kglobt18,                -- PARSING_SCHEMA_ID NUMBER
kglobts4,                -- PARSING_SCHEMA_NAME VARCHAR2(30)
kglhdkmk,                -- KEPT_VERSIONS NUMBER
kglobts0,                -- MODULE VARCHAR2(64)
kglobt19,                -- MODULE_HASH NUMBER
kglobts1,                -- ACTION VARCHAR2(64)
kglobt20,                -- ACTION_HASH NUMBER
kglobt21,                -- SERIALIZABLE_ABORTS NUMBER
kglobts2,                -- OUTLINE_CATEGORY VARCHAR2(64)
decode                   -- OUTLINE_SID VARCHAR2(40)
  (kglobt28, 0, NULL, kglobt28),
decode                   -- REMOTE VARCHAR2(1)
  (bitand (kglobt00, 64), 64, 'Y', 'N'),
decode                   -- OBJECT_STATUS VARCHAR2(19)
  (kglobsta, 1, 'VALID', 2, 'VALID_AUTH_ERROR', 3, 'VALID_COMPILE_ERROR', 4, 'VALID_UNAUTH', 5, 'INVALID_UNAUTH', 6, 'INVALID'),
kglobt31,                -- LITERAL_HASH_VALUE NUMBER
kglobts3,                -- SQL_PROFILE VARCHAR2(64)
kglobt44,                -- PROGRAM_ID NUMBER
kglobt45,                -- PROGRAM_LINE# NUMBER
kglobt47,                -- EXACT_MATCHING_SIGNATURE NUMBER
kglobt49,                -- FORCE_MATCHING_SIGNATURE NUMBER
kglobcbca                -- BIND_DATA RAW(2000)
from
x$kglcursor_child_sqlidph
home |  up  |  mailbox