select ADDRESS, -- ADDRESS RAW(8) HASH_VALUE, -- HASH_VALUE NUMBER SQL_ID, -- SQL_ID VARCHAR2(13) COMMAND_TYPE, -- COMMAND_TYPE NUMBER PIECE, -- PIECE NUMBER SQL_TEXT -- SQL_TEXT VARCHAR2(64) from GV$SQLTEXT_WITH_NEWLINES where inst_id = USERENV('Instance')