Oracle Internals
JulianDyke.com

Welcome

Consultancy

Seminars

Blog

Presentations

Diagnostics

Internals

 

Optimizer Hints

In Oracle 11.1 and above, a new dynamic performance view describes all supported hints together with information about the features they support, their inverse operation and the version in which they first appear.

In Oracle 11.1.0.7 there are 239 hints; in Oracle 11.2.0.1 there are 263 hints

The underlying fixed table is X$QKSHT which also contains the same number of rows as V$SQL_HINT. Therefore there is no concept of "hidden" hints in the same way that there are unsupported parameters for example

The following table summarizes the hints listed in Oracle 11.2.0.1:

NameVersionSQL FeatureClassInverse
ALL_ROWS8.1.0QKSFM_ALL_ROWSMODE
AND_EQUAL8.1.0QKSFM_AND_EQUALACCESS
ANTIJOIN9.0.0QKSFM_TRANSFORMATIONANTIJOIN
APPEND8.1.0QKSFM_CBOAPPENDNOAPPEND
APPEND_VALUES11.2.0.1QKSFM_CBOAPPEND_VALUESNOAPPEND
BIND_AWARE11.1.0.7QKSFM_CURSOR_SHARINGBIND_AWARENO_BIND_AWARE
BITMAP8.1.0QKSFM_CBOBITMAP
BITMAP_TREE10.2.0.1QKSFM_BITMAP_TREEACCESS
BUFFER8.1.5QKSFM_CBOBUFFERNO_BUFFER
BYPASS_RECURSIVE_CHECK9.0.0QKSFM_ALLBYPASS_RECURSIVE_CHECK
BYPASS_UJVC8.1.5QKSFM_CBOBYPASS_UJVC
CACHE8.1.0QKSFM_EXECUTIONCACHENOCACHE
CACHE_CB8.1.5QKSFM_CBOCACHE_CBNOCACHE
CACHE_TEMP_TABLE8.1.5QKSFM_ALLCACHENOCACHE
CARDINALITY9.0.0QKSFM_STATSCARDINALITY
CHANGE_DUPKEY_ERROR_INDEX11.1.0.7QKSFM_DMLCHANGE_DUPKEY_ERROR_INDEX
CHECK_ACL_REWRITE11.1.0.6QKSFM_CHECK_ACL_REWRITECHECK_ACL_REWRITENO_CHECK_ACL_REWRITE
CHOOSE8.1.0QKSFM_CHOOSEMODE
CLUSTER8.0.0QKSFM_CBOACCESS
COALESCE_SQ11.2.0.1QKSFM_COALESCE_SQCOALESCE_SQNO_COALESCE_SQ
COLUMN_STATS10.1.0.3QKSFM_STATSTABLE_STATS
CONNECT_BY_CB_WHR_ONLY10.2.0.5QKSFM_TRANSFORMATIONCONNECT_BY_CB_WHR_ONLYNO_CONNECT_BY_CB_WHR_ONLY
CONNECT_BY_COMBINE_SW10.2.0.4QKSFM_ALLCONNECT_BY_COMBINE_SWNO_CONNECT_BY_COMBINE_SW
CONNECT_BY_COST_BASED10.2.0.2QKSFM_TRANSFORMATIONCONNECT_BY_COST_BASEDNO_CONNECT_BY_COST_BASED
CONNECT_BY_ELIM_DUPS11.2.0.1QKSFM_ALLCONNECT_BY_ELIM_DUPSNO_CONNECT_BY_ELIM_DUPS
CONNECT_BY_FILTERING10.2.0.2QKSFM_ALLCONNECT_BY_FILTERINGNO_CONNECT_BY_FILTERING
COST_XML_QUERY_REWRITE11.1.0.6QKSFM_COST_XML_QUERY_REWRITECOST_XML_QUERY_REWRITENO_COST_XML_QUERY_REWRITE
CPU_COSTING9.0.0QKSFM_CPU_COSTINGCPU_COSTINGNO_CPU_COSTING
CUBE_GB8.1.5QKSFM_CBOCUBE_GB
CURSOR_SHARING_EXACT9.0.0QKSFM_CBOCURSOR_SHARING_EXACT
DBMS_STATS10.2.0.1QKSFM_DBMS_STATSDBMS_STATS
DB_VERSION11.1.0.6QKSFM_ALLDB_VERSION
DEREF_NO_REWRITE8.1.0QKSFM_ALLDEREF_NO_REWRITE
DML_UPDATE9.0.0QKSFM_CBODML_UPDATE
DOMAIN_INDEX_FILTER11.1.0.6QKSFM_CBODOMAIN_INDEX_FILTERNO_DOMAIN_INDEX_FILTER
DOMAIN_INDEX_NO_SORT8.1.5QKSFM_CBODOMAIN_INDEX_SORTDOMAIN_INDEX_SORT
DOMAIN_INDEX_SORT8.1.5QKSFM_CBODOMAIN_INDEX_SORTDOMAIN_INDEX_NO_SORT
DRIVING_SITE8.1.0QKSFM_ALLDRIVING_SITE
DST_UPGRADE_INSERT_CONV11.2.0.1QKSFM_ALLDST_UPGRADE_INSERT_CONVNO_DST_UPGRADE_INSERT_CONV
DYNAMIC_SAMPLING9.2.0QKSFM_DYNAMIC_SAMPLINGDYNAMIC_SAMPLING
DYNAMIC_SAMPLING_EST_CDN9.2.0QKSFM_DYNAMIC_SAMPLING_EST_CDNDYNAMIC_SAMPLING_EST_CDN
ELIMINATE_JOIN10.2.0.1QKSFM_TABLE_ELIMELIMINATE_JOINNO_ELIMINATE_JOIN
ELIMINATE_OBY10.2.0.1QKSFM_OBYEELIMINATE_OBYNO_ELIMINATE_OBY
EXPAND_GSET_TO_UNION9.2.0QKSFM_TRANSFORMATIONEXPAND_GSET_TO_UNIONNO_EXPAND_GSET_TO_UNION
EXPAND_TABLE11.2.0.1QKSFM_TABLE_EXPANSIONEXPAND_TABLENO_EXPAND_TABLE
EXPR_CORR_CHECK8.0.0QKSFM_CBOEXPR_CORR_CHECK
FACT8.1.0QKSFM_STAR_TRANSFACTNO_FACT
FACTORIZE_JOIN11.2.0.1QKSFM_JOINFACFACTORIZE_JOINNO_FACTORIZE_JOIN
FBTSCAN10.1.0.3QKSFM_CBOFBTSCAN
FIRST_ROWS8.1.0QKSFM_FIRST_ROWSMODE
FORCE_XML_QUERY_REWRITE9.2.0QKSFM_XML_REWRITEFORCE_XML_QUERY_REWRITENO_XML_QUERY_REWRITE
FULL8.1.0QKSFM_FULLACCESS
GATHER_PLAN_STATISTICS10.1.0.3QKSFM_GATHER_PLAN_STATISTICSGATHER_PLAN_STATISTICS
GBY_CONC_ROLLUP9.0.0QKSFM_TRANSFORMATIONGBY_CONC_ROLLUP
GBY_PUSHDOWN11.1.0.6QKSFM_ALLGBY_PUSHDOWNNO_GBY_PUSHDOWN
HASH8.1.0QKSFM_ALLACCESS
HASH_AJ8.1.0QKSFM_CBOANTIJOIN
HASH_SJ8.1.0QKSFM_CBOSEMIJOIN
HWM_BROKERED9.0.0QKSFM_CBOHWM_BROKERED
IGNORE_OPTIM_EMBEDDED_HINTS10.1.0.3QKSFM_ALLIGNORE_OPTIM_EMBEDDED_HINTS
IGNORE_ROW_ON_DUPKEY_INDEX11.1.0.7QKSFM_DMLIGNORE_ROW_ON_DUPKEY_INDEX
IGNORE_WHERE_CLAUSE9.2.0QKSFM_ALLIGNORE_WHERE_CLAUSE
INCLUDE_VERSION10.1.0.3QKSFM_ALLINCLUDE_VERSION
INDEX8.0.0QKSFM_INDEXACCESSNO_INDEX
INDEX_ASC8.1.0QKSFM_INDEX_ASCACCESSNO_INDEX
INDEX_COMBINE8.1.0QKSFM_INDEX_COMBINEACCESS
INDEX_DESC8.1.0QKSFM_INDEX_DESCACCESSNO_INDEX
INDEX_FFS8.1.0QKSFM_INDEX_FFSACCESS
INDEX_JOIN8.1.5QKSFM_INDEX_JOINACCESS
INDEX_RRS9.0.0QKSFM_CBOACCESS
INDEX_RS_ASC11.1.0.6QKSFM_INDEX_RS_ASCACCESS
INDEX_RS_DESC11.1.0.6QKSFM_INDEX_RS_DESCACCESS
INDEX_SS9.0.0QKSFM_INDEX_SSACCESSNO_INDEX_SS
INDEX_SS_ASC9.0.0QKSFM_INDEX_SS_ASCACCESSNO_INDEX_SS
INDEX_SS_DESC9.0.0QKSFM_INDEX_SS_DESCACCESSNO_INDEX_SS
INDEX_STATS10.1.0.3QKSFM_STATSTABLE_STATS
INLINE9.0.0QKSFM_TRANSFORMATIONINLINEMATERIALIZE
INLINE_XMLTYPE_NT10.2.0.1QKSFM_ALLINLINE_XMLTYPE_NT
LEADING8.1.6QKSFM_JOIN_ORDERLEADING
LIKE_EXPAND8.1.7QKSFM_TRANSFORMATIONLIKE_EXPAND
LOCAL_INDEXES9.0.0QKSFM_CBOLOCAL_INDEXES
MATERIALIZE9.0.0QKSFM_TRANSFORMATIONINLINEINLINE
MERGE8.1.0QKSFM_CVMMERGENO_MERGE
MERGE_AJ8.1.0QKSFM_CBOANTIJOIN
MERGE_CONST_ON8.0.0QKSFM_CBOMERGE_CONST_ON
MERGE_SJ8.1.0QKSFM_CBOSEMIJOIN
MODEL_COMPILE_SUBQUERY10.2.0.1QKSFM_TRANSFORMATIONMODEL_COMPILE_SUBQUERY
MODEL_DONTVERIFY_UNIQUENESS10.1.0.3QKSFM_TRANSFORMATIONMODEL_DONTVERIFY_UNIQUENESS
MODEL_DYNAMIC_SUBQUERY10.2.0.1QKSFM_TRANSFORMATIONMODEL_DYNAMIC_SUBQUERY
MODEL_MIN_ANALYSIS10.1.0.3QKSFM_TRANSFORMATIONMODEL_MIN_ANALYSIS
MODEL_NO_ANALYSIS10.1.0.3QKSFM_ALLMODEL_MIN_ANALYSIS
MODEL_PUSH_REF10.1.0.3QKSFM_TRANSFORMATIONMODEL_PUSH_REFNO_MODEL_PUSH_REF
MONITOR11.1.0.6QKSFM_ALLMONITORNO_MONITOR
MV_MERGE9.0.0QKSFM_TRANSFORMATIONMV_MERGE
NATIVE_FULL_OUTER_JOIN10.2.0.3QKSFM_ALLNATIVE_FULL_OUTER_JOINNO_NATIVE_FULL_OUTER_JOIN
NESTED_TABLE_FAST_INSERT10.1.0.3QKSFM_ALLNESTED_TABLE_FAST_INSERT
NESTED_TABLE_GET_REFS8.1.0QKSFM_ALLNESTED_TABLE_GET_REFS
NESTED_TABLE_SET_SETID8.1.5QKSFM_ALLNESTED_TABLE_SET_SETID
NLJ_BATCHING11.1.0.6QKSFM_EXECUTIONACCESSNO_NLJ_BATCHING
NLJ_PREFETCH11.1.0.6QKSFM_EXECUTIONACCESSNO_NLJ_PREFETCH
NL_AJ8.0.0QKSFM_CBOANTIJOIN
NL_SJ8.0.0QKSFM_CBOSEMIJOIN
NOAPPEND8.1.0QKSFM_CBOAPPENDAPPEND
NOCACHE8.1.0QKSFM_EXECUTIONCACHECACHE
NOPARALLEL8.1.0QKSFM_PARALLELSHAREDSHARED
NO_ACCESS8.1.5QKSFM_ALLNO_ACCESS
NO_BASETABLE_MULTIMV_REWRITE10.1.0.3QKSFM_ALLREWRITEREWRITE
NO_BIND_AWARE11.1.0.7QKSFM_CURSOR_SHARINGBIND_AWAREBIND_AWARE
NO_BUFFER8.1.5QKSFM_CBOBUFFERBUFFER
NO_CARTESIAN10.2.0.1QKSFM_ALLNO_CARTESIAN
NO_CHECK_ACL_REWRITE11.1.0.6QKSFM_CHECK_ACL_REWRITENO_CHECK_ACL_REWRITECHECK_ACL_REWRITE
NO_COALESCE_SQ11.2.0.1QKSFM_COALESCE_SQCOALESCE_SQCOALESCE_SQ
NO_CONNECT_BY_CB_WHR_ONLY10.2.0.5QKSFM_TRANSFORMATIONCONNECT_BY_CB_WHR_ONLYCONNECT_BY_CB_WHR_ONLY
NO_CONNECT_BY_COMBINE_SW10.2.0.4QKSFM_ALLCONNECT_BY_COMBINE_SWCONNECT_BY_COMBINE_SW
NO_CONNECT_BY_COST_BASED10.2.0.2QKSFM_TRANSFORMATIONCONNECT_BY_COST_BASEDCONNECT_BY_COST_BASED
NO_CONNECT_BY_ELIM_DUPS11.2.0.1QKSFM_ALLCONNECT_BY_ELIM_DUPSCONNECT_BY_ELIM_DUPS
NO_CONNECT_BY_FILTERING10.2.0.2QKSFM_ALLCONNECT_BY_FILTERINGCONNECT_BY_FILTERING
NO_COST_XML_QUERY_REWRITE11.1.0.6QKSFM_COST_XML_QUERY_REWRITENO_COST_XML_QUERY_REWRITECOST_XML_QUERY_REWRITE
NO_CPU_COSTING9.0.0QKSFM_CPU_COSTINGCPU_COSTINGCPU_COSTING
NO_DOMAIN_INDEX_FILTER11.1.0.6QKSFM_CBONO_DOMAIN_INDEX_FILTERDOMAIN_INDEX_FILTER
NO_DST_UPGRADE_INSERT_CONV11.2.0.1QKSFM_ALLDST_UPGRADE_INSERT_CONVDST_UPGRADE_INSERT_CONV
NO_ELIMINATE_JOIN10.2.0.1QKSFM_TABLE_ELIMELIMINATE_JOINELIMINATE_JOIN
NO_ELIMINATE_OBY10.2.0.1QKSFM_OBYEELIMINATE_OBYELIMINATE_OBY
NO_EXPAND8.1.0QKSFM_USE_CONCATUSE_CONCATUSE_CONCAT
NO_EXPAND_GSET_TO_UNION9.2.0QKSFM_TRANSFORMATIONEXPAND_GSET_TO_UNIONEXPAND_GSET_TO_UNION
NO_EXPAND_TABLE11.2.0.1QKSFM_TABLE_EXPANSIONEXPAND_TABLEEXPAND_TABLE
NO_FACT8.1.0QKSFM_STAR_TRANSFACTFACT
NO_FACTORIZE_JOIN11.2.0.1QKSFM_JOINFACFACTORIZE_JOINFACTORIZE_JOIN
NO_GBY_PUSHDOWN11.1.0.6QKSFM_ALLGBY_PUSHDOWNGBY_PUSHDOWN
NO_INDEX8.1.5QKSFM_INDEXNO_INDEXINDEX
NO_INDEX_FFS10.1.0.3QKSFM_INDEX_FFSNO_INDEX_FFSINDEX_FFS
NO_INDEX_SS10.1.0.3QKSFM_INDEX_SSNO_INDEX_SSINDEX_SS
NO_LOAD11.1.0.6QKSFM_EXECUTIONNO_LOAD
NO_MERGE8.0.0QKSFM_CVMMERGEMERGE
NO_MODEL_PUSH_REF10.1.0.3QKSFM_ALLMODEL_PUSH_REFMODEL_PUSH_REF
NO_MONITOR11.1.0.6QKSFM_ALLMONITORMONITOR
NO_MONITORING8.0.0QKSFM_ALLNO_MONITORING
NO_MULTIMV_REWRITE10.1.0.3QKSFM_ALLREWRITEREWRITE
NO_NATIVE_FULL_OUTER_JOIN10.2.0.3QKSFM_ALLNATIVE_FULL_OUTER_JOINNATIVE_FULL_OUTER_JOIN
NO_NLJ_BATCHING11.1.0.6QKSFM_EXECUTIONACCESSNLJ_BATCHING
NO_NLJ_PREFETCH11.1.0.6QKSFM_EXECUTIONACCESSNLJ_PREFETCH
NO_ORDER_ROLLUPS8.0.0QKSFM_TRANSFORMATIONNO_ORDER_ROLLUPS
NO_OUTER_JOIN_TO_INNER11.1.0.6QKSFM_OUTER_JOIN_TO_INNEROUTER_JOIN_TO_INNEROUTER_JOIN_TO_INNER
NO_PARALLEL10.1.0.3QKSFM_CBOSHAREDSHARED
NO_PARALLEL_INDEX8.1.0QKSFM_PQPARALLEL_INDEXPARALLEL_INDEX
NO_PARTIAL_COMMIT10.1.0.3QKSFM_CBONO_PARTIAL_COMMIT
NO_PLACE_DISTINCT11.2.0.1QKSFM_DIST_PLCMTPLACE_DISTINCTPLACE_DISTINCT
NO_PLACE_GROUP_BY11.1.0.6QKSFM_PLACE_GROUP_BYPLACE_GROUP_BYPLACE_GROUP_BY
NO_PRUNE_GSETS9.0.0QKSFM_TRANSFORMATIONNO_PRUNE_GSETS
NO_PULL_PRED10.2.0.1QKSFM_PULL_PREDPULL_PREDPULL_PRED
NO_PUSH_PRED8.1.0QKSFM_FILTER_PUSH_PREDPUSH_PREDPUSH_PRED
NO_PUSH_SUBQ9.2.0QKSFM_TRANSFORMATIONPUSH_SUBQPUSH_SUBQ
NO_PX_JOIN_FILTER10.2.0.1QKSFM_PX_JOIN_FILTERPX_JOIN_FILTERPX_JOIN_FILTER
NO_QKN_BUFF9.2.0QKSFM_CBONO_QKN_BUFF
NO_QUERY_TRANSFORMATION10.1.0.3QKSFM_TRANSFORMATIONNO_QUERY_TRANSFORMATION
NO_REF_CASCADE9.2.0QKSFM_CBOREF_CASCADE_CURSORREF_CASCADE_CURSOR
NO_RESULT_CACHE11.1.0.6QKSFM_EXECUTIONRESULT_CACHERESULT_CACHE
NO_REWRITE8.1.5QKSFM_TRANSFORMATIONREWRITEREWRITE
NO_SEMIJOIN9.0.0QKSFM_TRANSFORMATIONSEMIJOINSEMIJOIN
NO_SET_TO_JOIN10.1.0.3QKSFM_SET_TO_JOINSET_TO_JOINSET_TO_JOIN
NO_SQL_TUNE10.2.0.1QKSFM_ALLNO_SQL_TUNE
NO_STAR_TRANSFORMATION10.1.0.3QKSFM_STAR_TRANSSTAR_TRANSFORMATIONSTAR_TRANSFORMATION
NO_STATEMENT_QUEUING11.2.0.1QKSFM_PARALLELSTATEMENT_QUEUINGSTATEMENT_QUEUING
NO_STATS_GSETS8.0.0QKSFM_ALLNO_STATS_GSETS
NO_SUBQUERY_PRUNING11.1.0.6QKSFM_CBOSUBQUERY_PRUNINGSUBQUERY_PRUNING
NO_SUBSTRB_PAD11.2.0.1QKSFM_EXECUTIONNO_SUBSTRB_PAD
NO_SWAP_JOIN_INPUTS10.1.0.3QKSFM_CBOSWAP_JOIN_INPUTSSWAP_JOIN_INPUTS
NO_TRANSFORM_DISTINCT_AGG11.2.0.1QKSFM_TRANSFORMATIONTRANSFORM_DISTINCT_AGGTRANSFORM_DISTINCT_AGG
NO_UNNEST8.1.6QKSFM_UNNESTUNNESTUNNEST
NO_USE_HASH10.1.0.3QKSFM_USE_HASHNO_USE_HASHUSE_HASH
NO_USE_HASH_AGGREGATION10.2.0.1QKSFM_ALLUSE_HASH_AGGREGATIONUSE_HASH_AGGREGATION
NO_USE_INVISIBLE_INDEXES11.1.0.6QKSFM_INDEXUSE_INVISIBLE_INDEXESUSE_INVISIBLE_INDEXES
NO_USE_MERGE10.1.0.3QKSFM_USE_MERGENO_USE_MERGEUSE_MERGE
NO_USE_NL10.1.0.3QKSFM_USE_NLNO_USE_NLUSE_NL
NO_XMLINDEX_REWRITE11.1.0.6QKSFM_XMLINDEX_REWRITEXMLINDEX_REWRITEXMLINDEX_REWRITE
NO_XMLINDEX_REWRITE_IN_SELECT11.1.0.6QKSFM_XMLINDEX_REWRITEXMLINDEX_REWRITEXMLINDEX_REWRITE_IN_SELECT
NO_XML_DML_REWRITE10.2.0.1QKSFM_XML_REWRITENO_XML_DML_REWRITE
NO_XML_QUERY_REWRITE9.2.0QKSFM_XML_REWRITEFORCE_XML_QUERY_REWRITEFORCE_XML_QUERY_REWRITE
NUM_INDEX_KEYS10.2.0.3QKSFM_CBOACCESS
OLD_PUSH_PRED10.2.0.1QKSFM_OLD_PUSH_PREDOLD_PUSH_PRED
OPAQUE_TRANSFORM10.1.0.3QKSFM_TRANSFORMATIONOPAQUE_TRANSFORM
OPAQUE_XCANONICAL10.1.0.3QKSFM_TRANSFORMATIONOPAQUE_XCANONICAL
OPTIMIZER_FEATURES_ENABLE10.1.0.3QKSFM_ALLOPTIMIZER_FEATURES_ENABLE
OPT_ESTIMATE10.1.0.3QKSFM_OPT_ESTIMATEOPT_ESTIMATE
OPT_PARAM10.2.0.1QKSFM_ALLOPT_PARAM
ORDERED8.1.0QKSFM_CBOORDERED
ORDERED_PREDICATES8.0.0QKSFM_CBOORDERED_PREDICATES
OR_EXPAND8.1.7QKSFM_OR_EXPANDOR_EXPAND
OUTER_JOIN_TO_INNER11.1.0.6QKSFM_OUTER_JOIN_TO_INNEROUTER_JOIN_TO_INNERNO_OUTER_JOIN_TO_INNER
OUTLINE10.2.0.1QKSFM_ALLOUTLINE
OUTLINE_LEAF10.2.0.1QKSFM_ALLOUTLINE_LEAF
OVERFLOW_NOMOVE9.0.0QKSFM_CBOOVERFLOW_NOMOVE
PARALLEL_INDEX8.1.0QKSFM_PQPARALLEL_INDEXNO_PARALLEL_INDEX
PIV_GB8.1.0QKSFM_ALLPIV_GB
PIV_SSF8.1.0QKSFM_ALLPIV_SSF
PLACE_DISTINCT11.2.0.1QKSFM_DIST_PLCMTPLACE_DISTINCTNO_PLACE_DISTINCT
PLACE_GROUP_BY11.1.0.6QKSFM_PLACE_GROUP_BYPLACE_GROUP_BYNO_PLACE_GROUP_BY
PQ_DISTRIBUTE8.1.5QKSFM_PQ_DISTRIBUTEPQ_DISTRIBUTE
PQ_MAP9.0.0QKSFM_PQ_MAPPQ_MAPPQ_NOMAP
PQ_NOMAP9.0.0QKSFM_PQ_MAPPQ_MAPPQ_MAP
PRECOMPUTE_SUBQUERY10.2.0.1QKSFM_TRANSFORMATIONPRECOMPUTE_SUBQUERY
PRESERVE_OID10.2.0.1QKSFM_ALLPRESERVE_OID
PULL_PRED10.2.0.1QKSFM_PULL_PREDPULL_PREDNO_PULL_PRED
PUSH_PRED8.1.0QKSFM_FILTER_PUSH_PREDPUSH_PREDNO_PUSH_PRED
PUSH_SUBQ8.1.0QKSFM_TRANSFORMATIONPUSH_SUBQNO_PUSH_SUBQ
PX_JOIN_FILTER10.2.0.1QKSFM_PX_JOIN_FILTERPX_JOIN_FILTERNO_PX_JOIN_FILTER
QB_NAME10.1.0.3QKSFM_ALLQB_NAME
QUEUE_CURR8.0.0QKSFM_CBOACCESS
QUEUE_ROWP8.0.0QKSFM_CBOACCESS
RBO_OUTLINE10.2.0.1QKSFM_RBORBO_OUTLINE
REF_CASCADE_CURSOR9.2.0QKSFM_CBOREF_CASCADE_CURSORNO_REF_CASCADE
REMOTE_MAPPED8.1.0QKSFM_ALLREMOTE_MAPPED
RESTORE_AS_INTERVALS8.1.5QKSFM_CBORESTORE_AS_INTERVALS
RESTRICT_ALL_REF_CONS10.1.0.3QKSFM_ALLRESTRICT_ALL_REF_CONS
RESULT_CACHE11.1.0.6QKSFM_EXECUTIONRESULT_CACHENO_RESULT_CACHE
RETRY_ON_ROW_CHANGE11.1.0.7QKSFM_DMLRETRY_ON_ROW_CHANGE
REWRITE8.1.5QKSFM_TRANSFORMATIONREWRITENO_REWRITE
REWRITE_OR_ERROR10.1.0.3QKSFM_TRANSFORMATIONREWRITE
ROWID8.0.0QKSFM_CBOACCESS
RULE8.1.0QKSFM_RBOMODE
SAVE_AS_INTERVALS8.1.5QKSFM_CBOSAVE_AS_INTERVALS
SCN_ASCENDING8.1.5QKSFM_ALLSCN_ASCENDING
SEMIJOIN9.0.0QKSFM_TRANSFORMATIONSEMIJOINNO_SEMIJOIN
SEMIJOIN_DRIVER8.1.0QKSFM_CBOSEMIJOIN_DRIVER
SET_TO_JOIN10.1.0.3QKSFM_SET_TO_JOINSET_TO_JOINNO_SET_TO_JOIN
SHARED8.1.0QKSFM_PARALLELSHAREDNO_PARALLEL
SKIP_EXT_OPTIMIZER9.0.0QKSFM_CBOSKIP_EXT_OPTIMIZER
SKIP_UNQ_UNUSABLE_IDX10.1.0.3QKSFM_CBOSKIP_UNQ_UNUSABLE_IDX
SQLLDR9.0.0QKSFM_CBOSQLLDR
STAR8.1.0QKSFM_STAR_TRANSSTAR
STAR_TRANSFORMATION8.1.0QKSFM_STAR_TRANSSTAR_TRANSFORMATIONNO_STAR_TRANSFORMATION
STATEMENT_QUEUING11.2.0.1QKSFM_PARALLELSTATEMENT_QUEUINGNO_STATEMENT_QUEUING
STREAMS10.1.0.3QKSFM_CBOSTREAMS
SUBQUERY_PRUNING11.1.0.6QKSFM_CBOSUBQUERY_PRUNINGNO_SUBQUERY_PRUNING
SWAP_JOIN_INPUTS8.1.0QKSFM_CBOSWAP_JOIN_INPUTSNO_SWAP_JOIN_INPUTS
SYS_DL_CURSOR9.2.0QKSFM_CBOSYS_DL_CURSOR
SYS_PARALLEL_TXN8.1.6QKSFM_CBOSYS_PARALLEL_TXN
SYS_RID_ORDER9.2.0QKSFM_ALLSYS_RID_ORDER
TABLE_STATS10.1.0.3QKSFM_STATSTABLE_STATS
TIV_GB8.1.0QKSFM_ALLPIV_GB
TIV_SSF8.1.0QKSFM_ALLPIV_SSF
TRACING10.1.0.3QKSFM_EXECUTIONTRACING
TRANSFORM_DISTINCT_AGG11.2.0.1QKSFM_TRANSFORMATIONTRANSFORM_DISTINCT_AGGNO_TRANSFORM_DISTINCT_AGG
UNNEST8.1.6QKSFM_UNNESTUNNESTNO_UNNEST
USE_ANTI8.1.0QKSFM_CBOUSE_ANTI
USE_CONCAT8.1.0QKSFM_USE_CONCATUSE_CONCATNO_EXPAND
USE_HASH8.1.0QKSFM_USE_HASHJOINNO_USE_HASH
USE_HASH_AGGREGATION10.2.0.1QKSFM_ALLUSE_HASH_AGGREGATIONNO_USE_HASH_AGGREGATION
USE_INVISIBLE_INDEXES11.1.0.6QKSFM_INDEXUSE_INVISIBLE_INDEXESNO_USE_INVISIBLE_INDEXES
USE_MERGE8.1.0QKSFM_USE_MERGEJOINNO_USE_MERGE
USE_MERGE_CARTESIAN11.1.0.6QKSFM_USE_MERGE_CARTESIANJOIN
USE_NL8.1.0QKSFM_USE_NLJOINNO_USE_NL
USE_NL_WITH_INDEX10.1.0.3QKSFM_USE_NL_WITH_INDEXUSE_NL_WITH_INDEXNO_USE_NL
USE_SEMI8.1.0QKSFM_CBOUSE_SEMI
USE_TTT_FOR_GSETS9.0.0QKSFM_TRANSFORMATIONUSE_TTT_FOR_GSETS
USE_WEAK_NAME_RESL10.1.0.3QKSFM_ALLUSE_WEAK_NAME_RESL
VECTOR_READ10.1.0.3QKSFM_CBOVECTOR_READ
VECTOR_READ_TRACE10.1.0.3QKSFM_CBOVECTOR_READ_TRACE
XMLINDEX_REWRITE11.1.0.6QKSFM_XMLINDEX_REWRITEXMLINDEX_REWRITENO_XMLINDEX_REWRITE
XMLINDEX_REWRITE_IN_SELECT11.1.0.6QKSFM_XMLINDEX_REWRITEXMLINDEX_REWRITENO_XMLINDEX_REWRITE_IN_SELECT
XMLINDEX_SEL_IDX_TBL11.2.0.1QKSFM_ALLXMLINDEX_SEL_IDX_TBL
XML_DML_RWT_STMT11.1.0.6QKSFM_XML_REWRITEXML_DML_RWT_STMT
X_DYN_PRUNE10.1.0.3QKSFM_CBOX_DYN_PRUNE