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) |
