GV$SQLTEXT_WITH_NEWLINES definition in Oracle Database 11.2
GV$SQLTEXT_WITH_NEWLINES

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