select
  ADDRESS,                                 -- ADDRESS RAW(8)
  PARENT_HANDLE,                           -- PARENT_HANDLE RAW(8)
  HASH_VALUE,                              -- HASH_VALUE NUMBER
  SQL_ID,                                  -- SQL_ID VARCHAR2(13)
  CHILD_NUMBER,                            -- CHILD_NUMBER NUMBER
  PARSING_USER_ID,                         -- PARSING_USER_ID NUMBER
  PARSING_SCHEMA_ID,                       -- PARSING_SCHEMA_ID NUMBER
  COMMAND_TYPE,                            -- COMMAND_TYPE NUMBER
  REASON,                                  -- REASON VARCHAR2(14)
  ERROR_CODE,                              -- ERROR_CODE NUMBER
  POSITION,                                -- POSITION NUMBER
  SQL_TEXT_PIECE,                          -- SQL_TEXT_PIECE VARCHAR2(1000)
  ERROR_MESSAGE                            -- ERROR_MESSAGE VARCHAR2(1000)
from
  GV$SQL_REDIRECTION
where
  inst_id = USERENV('Instance')