V$SQL_REDIRECTION

This view identifies SQL statements that are redirected.

Column	Datatype	Description
ADDRESS	RAW(4)	KGL address
PARENT_HANDLE	RAW(4)	KGL address of parent
HASH_VALUE	NUMBER	SQL hash
CHILD_NUMBER	NUMBER	Number of child (instance) for hash
PARSING_USER_ID	NUMBER
PARSING_SCHEMA_ID	NUMBER
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