select
  c.inst_id,                               -- INST_ID NUMBER
  c.kglhdadr,                              -- ADDRESS RAW(8)
  c.kglhdpar,                              -- PARENT_HANDLE RAW(8)
  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