GV$SQLTEXT_WITH_NEWLINES
select inst_id, -- INST_ID NUMBER kglhdadr, -- ADDRESS RAW(4) kglnahsh, -- HASH_VALUE NUMBER kglnasqlid, -- SQL_ID VARCHAR2(13) kgloboct, -- COMMAND_TYPE NUMBER piece, -- PIECE NUMBER name -- SQL_TEXT VARCHAR2(64) from x$kglna1 where kgloboct != 0

home |  up  |  mailbox