Oracle9i Database Reference
Release 1 (9.0.1)

Part Number A90190-02
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents
Go To Index
Index

Master Index

Feedback

Go to previous page Go to beginning of chapter Go to next page

Dynamic Performance (V$) Views, 179 of 211


V$SQL_SHARED_CURSOR

This view describes 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 

ADDRESS 

RAW(4) 

Address of the child cursor 

KGLHDPAR 

RAW(4) 

(Y| N) Address of the pattern cursor 

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)

 


Go to previous page Go to beginning of chapter Go to next page
Oracle
Copyright © 1996-2001, Oracle Corporation.

All Rights Reserved.
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents
Go To Index
Index

Master Index

Feedback