GV$SQL
select inst_id, -- INST_ID NUMBER kglnaobj, -- SQL_TEXT VARCHAR2(1000) kglobhs0+kglobhs1+kglobhs2+kglobhs3+kglobhs4+kglobhs5+kglobhs6+kglobt16, -- SHARABLE_MEM NUMBER kglobt08+kglobt11, -- PERSISTENT_MEM NUMBER kglobt10, -- RUNTIME_MEM NUMBER kglobt01, -- SORTS NUMBER decode -- LOADED_VERSIONS NUMBER (kglobhs6, 0, 0, 1), decode -- OPEN_VERSIONS NUMBER (kglhdlmd, 0, 0, 1), kglhdlkc, -- USERS_OPENING NUMBER kglhdexc, -- EXECUTIONS NUMBER kglobpc6, -- USERS_EXECUTING NUMBER kglhdldc, -- LOADS NUMBER substr -- FIRST_LOAD_TIME VARCHAR2(19) (to_char (kglnatim, 'YYYY-MM-DD/HH24:MI:SS'), 1, 19), kglhdivc, -- INVALIDATIONS NUMBER kglobt12, -- PARSE_CALLS NUMBER kglobt13, -- DISK_READS NUMBER kglobt14, -- BUFFER_GETS 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 kglobt17, -- PARSING_USER_ID NUMBER kglobt18, -- PARSING_SCHEMA_ID NUMBER kglhdkmk, -- KEPT_VERSIONS NUMBER kglhdpar, -- ADDRESS RAW(4) kglobtp0, -- TYPE_CHK_HEAP RAW(4) kglnahsh, -- HASH_VALUE NUMBER kglobt09, -- CHILD_NUMBER 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) from x$kglcursor where kglhdadr != kglhdpar and kglobt02 != 0

home |  up  |  mailbox