Skip Headers

Oracle® Database Reference
10g Release 1 (10.1)

Part Number B10755-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_SHARED_CURSOR

This view explains why a particular child cursor is not shared with existing child cursors. Each column identifies a specific reason why the cursor cannot be shared.

Column Datatype Description
SQL_ID VARCHAR2(13) SQL identifier
ADDRESS RAW(4 | 8) Address of the parent cursor
CHILD_ADDRESS RAW(4 | 8) Address of the child cursor
CHILD_NUMBER NUMBER Child number
UNBOUND_CURSOR VARCHAR2(1) (Y|N) The existing child cursor was not fully built (in other words, it was not optimized)
SQL_TYPE_MISMATCH VARCHAR2(1) (Y|N) The SQL type does not match the existing child cursor
OPTIMIZER_MISMATCH VARCHAR2(1) (Y|N) The optimizer environment does not match the existing child cursor
OUTLINE_MISMATCH VARCHAR2(1) (Y|N) The outlines do not match the existing child cursor
STATS_ROW_MISMATCH VARCHAR2(1) (Y|N) The existing statistics do not match the existing child cursor
LITERAL_MISMATCH VARCHAR2(1) (Y|N) Non-data literal values do not match the existing child cursor
SEC_DEPTH_MISMATCH VARCHAR2(1) (Y|N) Security level does not match the existing child cursor
EXPLAIN_PLAN_CURSOR VARCHAR2(1) (Y|N) The child cursor is an explain plan cursor and should not be shared
BUFFERED_DML_MISMATCH VARCHAR2(1) (Y|N) Buffered DML does not match the existing child cursor
PDML_ENV_MISMATCH VARCHAR2(1) (Y|N) PDML environment does not match the existing child cursor
INST_DRTLD_MISMATCH VARCHAR2(1) (Y|N) Insert direct load does not match the existing child cursor
SLAVE_QC_MISMATCH VARCHAR2(1) (Y|N) The existing child cursor is a slave cursor and the new one was issued by the coordinator (or, the existing child cursor was issued by the coordinator and the new one is a slave cursor)
TYPECHECK_MISMATCH VARCHAR2(1) (Y|N) The existing child cursor is not fully optimized
AUTH_CHECK_MISMATCH VARCHAR2(1) (Y|N) Authorization/translation check failed for the existing child cursor
BIND_MISMATCH VARCHAR2(1) (Y|N) The bind metadata does not match the existing child cursor
DESCRIBE_MISMATCH VARCHAR2(1) (Y|N) The typecheck heap is not present during the describe for the child cursor
LANGUAGE_MISMATCH VARCHAR2(1) (Y|N) The language handle does not match the existing child cursor
TRANSLATION_MISMATCH VARCHAR2(1) (Y|N) The base objects of the existing child cursor do not match
ROW_LEVEL_SEC_MISMATCH VARCHAR2(1) (Y|N) The row level security policies do not match
INSUFF_PRIVS VARCHAR2(1) (Y|N) Insufficient privileges on objects referenced by the existing child cursor
INSUFF_PRIVS_REM VARCHAR2(1) (Y|N) Insufficient privileges on remote objects referenced by the existing child cursor
REMOTE_TRANS_MISMATCH VARCHAR2(1) (Y|N) The remote base objects of the existing child cursor do not match
LOGMINER_SESSION_MISMATCH VARCHAR2(1) (Y|N)
INCOMP_LTRL_MISMATCH VARCHAR2(1) (Y|N)