GV$SQL_REDIRECTION

select
c.inst_id,               -- INST_ID NUMBER
c.kglhdadr,              -- ADDRESS RAW(4)
c.kglhdpar,              -- PARENT_HANDLE RAW(4)
c.kglnahsh,              -- HASH_VALUE NUMBER
c.kglobt03,              -- SQL_ID VARCHAR2(13)
c.kglobt09,              -- CHILD_NUMBER NUMBER
c.kglobt17,              -- PARSING_USER_ID NUMBER
c.kglobt18,              -- PARSING_SCHEMA_ID NUMBER
c.kglobt02,              -- COMMAND_TYPE NUMBER
decode                   -- REASON VARCHAR2(14)
  (r.reason, 1, 'INVALID OBJECT', 2, 'ROWID', 3, 'QUERY REWRITE', 'READ ONLY'),
r.error_code,            -- ERROR_CODE NUMBER
r.position,              -- POSITION NUMBER
r.sql_text_piece,        -- SQL_TEXT_PIECE VARCHAR2(1000)
r.error_msg              -- ERROR_MESSAGE VARCHAR2(1000)
from
x$kglcursor_child c,
x$kkssrd r 
where
c.kglhdpar = r.parAddr and c.kglhdadr = r.kglhdadr
home |  up  |  mailbox