GV$SQL_REDIRECTION definition in Oracle 9i / www.oracledba.ru
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.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 c,
x$kkssrd r
where
c.kglhdadr != c.kglhdpar and c.kglobt02 != 0 and c.kglhdpar=r.parAddr and c.kglhdadr = r.kglhdadr