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