DBA Data[Home] [Help]

VIEW: SYS.GV_$SQL_REDIRECTION

Source

View Text - Preformatted

select "INST_ID","ADDRESS","PARENT_HANDLE","HASH_VALUE","SQL_ID","CHILD_NUMBER","PARSING_USER_ID","PARSING_SCHEMA_ID","COMMAND_TYPE","REASON","ERROR_CODE","POSITION","SQL_TEXT_PIECE","ERROR_MESSAGE","CON_ID" from gv$sql_redirection
View Text - HTML Formatted

SELECT "INST_ID"
, "ADDRESS"
, "PARENT_HANDLE"
, "HASH_VALUE"
, "SQL_ID"
, "CHILD_NUMBER"
, "PARSING_USER_ID"
, "PARSING_SCHEMA_ID"
, "COMMAND_TYPE"
, "REASON"
, "ERROR_CODE"
, "POSITION"
, "SQL_TEXT_PIECE"
, "ERROR_MESSAGE"
, "CON_ID"
FROM GV$SQL_REDIRECTION