V$SQL_REDIRECTION identifies 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 |