Skip Headers
Oracle® Database Reference
10g Release 2 (10.2)

Part Number B14237-01
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Feedback

Go to previous page
Previous
Go to next page
Next
View PDF

V$SQL_REDIRECTION

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