eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

VIEW: SYS.V_$SQL_SHARED_CURSOR

Object Details

Object Name:	V_$SQL_SHARED_CURSOR
Object Type:	VIEW
Owner:	SYS
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length
SQL_ID	VARCHAR2	(13)
ADDRESS	RAW	(8)
CHILD_ADDRESS	RAW	(8)
CHILD_NUMBER	NUMBER
UNBOUND_CURSOR	VARCHAR2	(1)
SQL_TYPE_MISMATCH	VARCHAR2	(1)
OPTIMIZER_MISMATCH	VARCHAR2	(1)
OUTLINE_MISMATCH	VARCHAR2	(1)
STATS_ROW_MISMATCH	VARCHAR2	(1)
LITERAL_MISMATCH	VARCHAR2	(1)
FORCE_HARD_PARSE	VARCHAR2	(1)
EXPLAIN_PLAN_CURSOR	VARCHAR2	(1)
BUFFERED_DML_MISMATCH	VARCHAR2	(1)
PDML_ENV_MISMATCH	VARCHAR2	(1)
INST_DRTLD_MISMATCH	VARCHAR2	(1)
SLAVE_QC_MISMATCH	VARCHAR2	(1)
TYPECHECK_MISMATCH	VARCHAR2	(1)
AUTH_CHECK_MISMATCH	VARCHAR2	(1)
BIND_MISMATCH	VARCHAR2	(1)
DESCRIBE_MISMATCH	VARCHAR2	(1)
LANGUAGE_MISMATCH	VARCHAR2	(1)
TRANSLATION_MISMATCH	VARCHAR2	(1)
BIND_EQUIV_FAILURE	VARCHAR2	(1)
INSUFF_PRIVS	VARCHAR2	(1)
INSUFF_PRIVS_REM	VARCHAR2	(1)
REMOTE_TRANS_MISMATCH	VARCHAR2	(1)
LOGMINER_SESSION_MISMATCH	VARCHAR2	(1)
INCOMP_LTRL_MISMATCH	VARCHAR2	(1)
OVERLAP_TIME_MISMATCH	VARCHAR2	(1)
EDITION_MISMATCH	VARCHAR2	(1)
MV_QUERY_GEN_MISMATCH	VARCHAR2	(1)
USER_BIND_PEEK_MISMATCH	VARCHAR2	(1)
TYPCHK_DEP_MISMATCH	VARCHAR2	(1)
NO_TRIGGER_MISMATCH	VARCHAR2	(1)
FLASHBACK_CURSOR	VARCHAR2	(1)
ANYDATA_TRANSFORMATION	VARCHAR2	(1)
PDDL_ENV_MISMATCH	VARCHAR2	(1)
TOP_LEVEL_RPI_CURSOR	VARCHAR2	(1)
DIFFERENT_LONG_LENGTH	VARCHAR2	(1)
LOGICAL_STANDBY_APPLY	VARCHAR2	(1)
DIFF_CALL_DURN	VARCHAR2	(1)
BIND_UACS_DIFF	VARCHAR2	(1)
PLSQL_CMP_SWITCHS_DIFF	VARCHAR2	(1)
CURSOR_PARTS_MISMATCH	VARCHAR2	(1)
STB_OBJECT_MISMATCH	VARCHAR2	(1)
CROSSEDITION_TRIGGER_MISMATCH	VARCHAR2	(1)
PQ_SLAVE_MISMATCH	VARCHAR2	(1)
TOP_LEVEL_DDL_MISMATCH	VARCHAR2	(1)
MULTI_PX_MISMATCH	VARCHAR2	(1)
BIND_PEEKED_PQ_MISMATCH	VARCHAR2	(1)
MV_REWRITE_MISMATCH	VARCHAR2	(1)
ROLL_INVALID_MISMATCH	VARCHAR2	(1)
OPTIMIZER_MODE_MISMATCH	VARCHAR2	(1)
PX_MISMATCH	VARCHAR2	(1)
MV_STALEOBJ_MISMATCH	VARCHAR2	(1)
FLASHBACK_TABLE_MISMATCH	VARCHAR2	(1)
LITREP_COMP_MISMATCH	VARCHAR2	(1)
PLSQL_DEBUG	VARCHAR2	(1)
LOAD_OPTIMIZER_STATS	VARCHAR2	(1)
ACL_MISMATCH	VARCHAR2	(1)
FLASHBACK_ARCHIVE_MISMATCH	VARCHAR2	(1)
LOCK_USER_SCHEMA_FAILED	VARCHAR2	(1)
REMOTE_MAPPING_MISMATCH	VARCHAR2	(1)
LOAD_RUNTIME_HEAP_FAILED	VARCHAR2	(1)
HASH_MATCH_FAILED	VARCHAR2	(1)
PURGED_CURSOR	VARCHAR2	(1)
BIND_LENGTH_UPGRADEABLE	VARCHAR2	(1)
USE_FEEDBACK_STATS	VARCHAR2	(1)
REASON	CLOB	(4000)
CON_ID	NUMBER

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT SQL_ID
,      ADDRESS
,      CHILD_ADDRESS
,      CHILD_NUMBER
,      UNBOUND_CURSOR
,      SQL_TYPE_MISMATCH
,      OPTIMIZER_MISMATCH
,      OUTLINE_MISMATCH
,      STATS_ROW_MISMATCH
,      LITERAL_MISMATCH
,      FORCE_HARD_PARSE
,      EXPLAIN_PLAN_CURSOR
,      BUFFERED_DML_MISMATCH
,      PDML_ENV_MISMATCH
,      INST_DRTLD_MISMATCH
,      SLAVE_QC_MISMATCH
,      TYPECHECK_MISMATCH
,      AUTH_CHECK_MISMATCH
,      BIND_MISMATCH
,      DESCRIBE_MISMATCH
,      LANGUAGE_MISMATCH
,      TRANSLATION_MISMATCH
,      BIND_EQUIV_FAILURE
,      INSUFF_PRIVS
,      INSUFF_PRIVS_REM
,      REMOTE_TRANS_MISMATCH
,      LOGMINER_SESSION_MISMATCH
,      INCOMP_LTRL_MISMATCH
,      OVERLAP_TIME_MISMATCH
,      EDITION_MISMATCH
,      MV_QUERY_GEN_MISMATCH
,      USER_BIND_PEEK_MISMATCH
,      TYPCHK_DEP_MISMATCH
,      NO_TRIGGER_MISMATCH
,      FLASHBACK_CURSOR
,      ANYDATA_TRANSFORMATION
,      PDDL_ENV_MISMATCH
,      TOP_LEVEL_RPI_CURSOR
,      DIFFERENT_LONG_LENGTH
,      LOGICAL_STANDBY_APPLY
,      DIFF_CALL_DURN
,      BIND_UACS_DIFF
,      PLSQL_CMP_SWITCHS_DIFF
,      CURSOR_PARTS_MISMATCH
,      STB_OBJECT_MISMATCH
,      CROSSEDITION_TRIGGER_MISMATCH
,      PQ_SLAVE_MISMATCH
,      TOP_LEVEL_DDL_MISMATCH
,      MULTI_PX_MISMATCH
,      BIND_PEEKED_PQ_MISMATCH
,      MV_REWRITE_MISMATCH
,      ROLL_INVALID_MISMATCH
,      OPTIMIZER_MODE_MISMATCH
,      PX_MISMATCH
,      MV_STALEOBJ_MISMATCH
,      FLASHBACK_TABLE_MISMATCH
,      LITREP_COMP_MISMATCH
,      PLSQL_DEBUG
,      LOAD_OPTIMIZER_STATS
,      ACL_MISMATCH
,      FLASHBACK_ARCHIVE_MISMATCH
,      LOCK_USER_SCHEMA_FAILED
,      REMOTE_MAPPING_MISMATCH
,      LOAD_RUNTIME_HEAP_FAILED
,      HASH_MATCH_FAILED
,      PURGED_CURSOR
,      BIND_LENGTH_UPGRADEABLE
,      USE_FEEDBACK_STATS
,      REASON
,      CON_ID
FROM SYS.V_$SQL_SHARED_CURSOR;

Dependencies

[top of page]

SYS.V_$SQL_SHARED_CURSOR references the following:

SYS.V_$SQL_SHARED_CURSOR is referenced by following:

PUBLIC: V$SQL_SHARED_CURSOR