Skip Headers

Oracle9i Database Reference
Release 2 (9.2)

Part Number A96536-02
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 Go to next page
View PDF

V$SQL_REDIRECTION

This view identifies SQL statements that are redirected.

Column Datatype Description

ADDRESS

RAW(4 | 8)

KGL address

PARENT_HANDLE

RAW(4 | 8)

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