V$SQL_REDIRECTION

V$SQL_REDIRECTION displays SQL statements that are redirected.

Column	Datatype	Description
`ADDRESS`	`RAW(4 \| 8)`	Address of the cursor handle
`PARENT_HANDLE`	`RAW(4 \| 8)`	Address of the parent cursor handle
`HASH_VALUE`	`NUMBER`	Hash value of the SQL statement
`SQL_ID`	`VARCHAR2(13)`	SQL identifier of the SQL statement
`CHILD_NUMBER`	`NUMBER`	Number of the child (instance) for the hash
`PARSING_USER_ID`	`NUMBER`	Parsing user ID
`PARSING_SCHEMA_ID`	`NUMBER`	Parsing schema ID
`COMMAND_TYPE`	`NUMBER`	`SELECT`, `UPDATE`, `INSERT`, `MERGE`
`REASON`	`VARCHAR2(14)`	Reason for redirection (`'INVALID OBJECT'`, `'ROWID'`, `'QUERY REWRITE'`, `'READ ONLY'`)
`ERROR_CODE`	`NUMBER`	Error code for local parse
`POSITION`	`NUMBER`	Error position, 0 if unknown
`SQL_TEXT_PIECE`	`VARCHAR2(1000)`	SQL Text containing position, usually a (qualified) identifier
`ERROR_MESSAGE`	`VARCHAR2(1000)`	Error code's corresponding error message resolved in the database language, no arguments resolved
`CON_ID`	`NUMBER`	The ID of the container to which the data pertains. Possible values include: `0`: This value is used for rows containing data that pertain to the entire CDB. This value is also used for rows in non-CDBs. `1`: This value is used for rows containing data that pertain to only the root n: Where n is the applicable container ID for the rows containing data