GV$SQL definition in Oracle 8i / www.oracledba.ru
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