V$SQL_SHARED_CURSOR 视图实验

V$SQL_SHARED_CURSOR 视图全实验

一、V$SQL_SHARED_CURSOR 数据结构

V$SQL_SHARED_CURSOR 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.
SQL_ID -- SQL identifier
ADDRESS -- Address of the parent cursor
CHILD_ADDRESS--Address of the child cursor
CHILD_NUMBER-- Child number
UNBOUND_CURSOR--(Y|N) The existing child cursor was not fully built (in other words, it was not optimized)
SQL_TYPE_MISMATCH--(Y|N) The SQL type does not match the existing child cursor
OPTIMIZER_MISMATCH--(Y|N) The optimizer environment does not match the existing child cursor
OUTLINE_MISMATCH--(Y|N) The outlines do not match the existing child cursor
STATS_ROW_MISMATCH--(Y|N) The existing statistics do not match the existing child cursor
LITERAL_MISMATCH--(Y|N) Non-data literal values do not match the existing child cursor
SEC_DEPTH_MISMATCH--(Y|N) Security level does not match the existing child cursor
EXPLAIN_PLAN_CURSOR--(Y|N) The child cursor is an explain plan cursor and should not be shared
BUFFERED_DML_MISMATCH--(Y|N) Buffered DML does not match the existing child cursor
PDML_ENV_MISMATCH--(Y|N) PDML environment does not match the existing child cursor
INST_DRTLD_MISMATCH--(Y|N) Insert direct load does not match the existing child cursor
SLAVE_QC_MISMATCH--(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--(Y|N) The existing child cursor is not fully optimized
AUTH_CHECK_MISMATCH--(Y|N) Authorization/translation check failed for the existing child cursor
BIND_MISMATCH--(Y|N) The bind metadata does not match the existing child cursor
DESCRIBE_MISMATCH--(Y|N) The typecheck heap is not present during the describe for the child cursor
LANGUAGE_MISMATCH---(Y|N) The language handle does not match the existing child cursor
TRANSLATION_MISMATCH--(Y|N) The base objects of the existing child cursor do not match
ROW_LEVEL_SEC_MISMATCH--(Y|N) The row level security policies do not match
INSUFF_PRIVS--(Y|N) Insufficient privileges on objects referenced by the existing child cursor
INSUFF_PRIVS_REM--(Y|N) Insufficient privileges on remote objects referenced by the existing child cursor
REMOTE_TRANS_MISMATCH--(Y|N) The remote base objects of the existing child cursor do not match
LOGMINER_SESSION_MISMATCH--(Y|N) LogMiner Session parameters mismatch
INCOMP_LTRL_MISMATCH--(Y|N) Cursor might have some binds (literals) which may be unsafe/non-data. Value mismatch.
OVERLAP_TIME_MISMATCH--Mismatch caused by setting session parameter ERROR_ON_OVERLAP_TIME
SQL_REDIRECT_MISMATCH--SQL redirection mismatch
MV_QUERY_GEN_MISMATCH--Internal, used to force a hard-parse when analyzing materialized view queries
USER_BIND_PEEK_MISMATCH--Cursor is not shared because value of one or more user binds is different and this has a potential to change the execution plan
TYPCHK_DEP_MISMATCH--Cursor has typecheck dependencies
NO_TRIGGER_MISMATCH--Cursor and child have no trigger mismatch
FLASHBACK_CURSOR--Cursor non-shareability due to flashback
ANYDATA_TRANSFORMATION--Is criteria for opaque type transformation and does not match
INCOMPLETE_CURSOR--Cursor is incomplete: typecheck heap came from call memory
TOP_LEVEL_RPI_CURSOR --Is top level RPI cursor
DIFFERENT_LONG_LENGTH--Value of LONG does not match
LOGICAL_STANDBY_APPLY--Logical standby apply context does not match
DIFF_CALL_DURN--If Slave SQL cursor/single call
BIND_UACS_DIFF--One cursor has bind UACs and one does not
PLSQL_CMP_SWITCHS_DIFF--PL/SQL anonymous block compiled with different PL/SQL compiler switches
CURSOR_PARTS_MISMATCH--Cursor was compiled with subexecution (cursor parts were executed)
STB_OBJECT_MISMATCH--STB has come into existence since cursor was compiled
ROW_SHIP_MISMATCH--Session does not support row shipping, but cursor built in one that did
PQ_SLAVE_MISMATCH--Top-level slave decides not to share cursor
TOP_LEVEL_DDL_MISMATCH--Is top-level DDL cursor
MULTI_PX_MISMATCH--Cursor has multiple parallelizers and is slave-compiled
BIND_PEEKED_PQ_MISMATCH--Cursor based around bind peeked values
MV_REWRITE_MISMATCH--Cursor needs recompilation because an SCN was used during compile time due to being rewritten by materialized view
ROLL_INVALID_MISMATCH--Marked for rolling invalidation and invalidation window exceeded
OPTIMIZER_MODE_MISMATCH--Parameter OPTIMIZER_MODE mismatch (for example, all_rows versus first_rows_1)
PX_MISMATCH--Mismatch in one parameter affecting the parallelization of a SQL statement. For example, one cursor was compiled with parallel DML enabled while

the other was not.
MV_STALEOBJ_MISMATCH--Cursor cannot be shared because there is a mismatch in the list of materialized views which were stale at the time the cursor was built
FLASHBACK_TABLE_MISMATCH--Cursor cannot be shared because there is a mismatch with triggers being enabled and/or referential integrity constraints being

deferred
LITREP_COMP_MISMATCH--Mismatch in use of literal replacement

二，

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/15489979/viewspace-742974/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/15489979/viewspace-742974/