GV$SQL definition in Oracle Database 10.2 / www.oracledba.ru
GV$SQL
select
inst_id, -- INST_ID NUMBER
kglnaobj, -- SQL_TEXT VARCHAR2(1000)
kglfnobj, -- SQL_FULLTEXT CLOB
kglobt03, -- SQL_ID VARCHAR2(13)
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
kglobt48, -- PX_SERVERS_EXECUTIONS NUMBER
kglobt35, -- END_OF_FETCH_COUNT 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
kglobwdw, -- DIRECT_WRITES NUMBER
kglobt14, -- BUFFER_GETS 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
kglhdpar, -- ADDRESS RAW(4)
kglobtp0, -- TYPE_CHK_HEAP RAW(4)
kglnahsh, -- HASH_VALUE NUMBER
kglobt46, -- OLD_HASH_VALUE NUMBER
kglobt30, -- PLAN_HASH_VALUE NUMBER
kglobt09, -- CHILD_NUMBER NUMBER
kglobts5, -- SERVICE VARCHAR2(64)
kglobt48, -- SERVICE_HASH 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
decode -- OUTLINE_SID NUMBER
(kglobt28, 0, to_number (NULL), kglobt28),
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
kglobts3, -- SQL_PROFILE VARCHAR2(64)
kglobt44, -- PROGRAM_ID NUMBER
kglobt45, -- PROGRAM_LINE# NUMBER
kglobt47, -- EXACT_MATCHING_SIGNATURE NUMBER
kglobt49, -- FORCE_MATCHING_SIGNATURE NUMBER
kglobcla, -- LAST_ACTIVE_TIME DATE
kglobcbca -- BIND_DATA RAW(2000)
from
x$kglcursor_child