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
kglobt04,                -- FETCHES NUMBER
kglobt05,                -- 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
kglobt30,                -- PLAN_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)
kglobt06,                -- CPU_TIME NUMBER
kglobt07,                -- ELAPSED_TIME NUMBER
kglobt28,                -- OUTLINE_SID NUMBER
kglhdadr,                -- CHILD_ADDRESS RAW(4)
kglobt29,                -- SQLTYPE NUMBER
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
substr                   -- LAST_LOAD_TIME VARCHAR2(19)
  (to_char (kglobtt0, 'YYYY-MM-DD/HH24:MI:SS'), 1, 19),
decode                   -- IS_OBSOLETE VARCHAR2(1)
  (kglobt33, 1, 'Y', 'N'),
kglhdclt                 -- CHILD_LATCH NUMBER
from
x$kglcursor 
where
kglhdadr != kglhdpar and kglobt02 != 0 

home |  up  |  mailbox