Call now: 252-767-6166  
Oracle Training Oracle Support Development Oracle Apps

 
 Home
 E-mail Us
 Oracle Articles
New Oracle Articles


 Oracle Training
 Oracle Tips

 Oracle Forum
 Class Catalog


 Remote DBA
 Oracle Tuning
 Emergency 911
 RAC Support
 Apps Support
 Analysis
 Design
 Implementation
 Oracle Support


 SQL Tuning
 Security

 Oracle UNIX
 Oracle Linux
 Monitoring
 Remote s
upport
 Remote plans
 Remote
services
 Application Server

 Applications
 Oracle Forms
 Oracle Portal
 App Upgrades
 SQL Server
 Oracle Concepts
 Software Support

 Remote S
upport  
 Development  

 Implementation


 Consulting Staff
 Consulting Prices
 Help Wanted!

 


 Oracle Posters
 Oracle Books

 Oracle Scripts
 Ion
 Excel-DB  

Don Burleson Blog 


 

 

 


 

 

 
 

Using v$sql_hint

Oracle Database Tips by Donald BurlesonApril 5,  2015

 
Starting in Oracle 11g, we have a great new view v$sql_hint which categorizes hints and shows the Oracle release when the hint was first introduced.  The v$sql_hint view also show the "inverse" of the hint, the hint that negates the optimizer directive.
For more on 11g new features, see the book "Oracle 11g New Features" authored by John Garmany, with Oracle ACE's Steve Karam, Lutz Hartmann, V.J. Jain and Brian Carr.
 
Here, we see the 148 "classes" of Oracle hints, broad hint classifications:
 
SQL> select distinct class from v$sql_hint order by class;

CLASS
----------------------------------------------------------------
ACCESS
ANTIJOIN
APPEND
BITMAP
BUFFER
BYPASS_RECURSIVE_CHECK
BYPASS_UJVC
CACHE
CACHE_CB
CARDINALITY
CHECK_ACL_REWRITE
CONNECT_BY_COMBINE_SW
CONNECT_BY_COST_BASED
CONNECT_BY_FILTERING
COST_XML_QUERY_REWRITE
CPU_COSTING
CUBE_GB
CURSOR_SHARING_EXACT
DBMS_STATS
DB_VERSION
DEREF_NO_REWRITE
DML_UPDATE
DOMAIN_INDEX_FILTER
DOMAIN_INDEX_SORT
DRIVING_SITE
DYNAMIC_SAMPLING
DYNAMIC_SAMPLING_EST_CDN
ELIMINATE_JOIN
ELIMINATE_OBY
EXPAND_GSET_TO_UNION
EXPR_CORR_CHECK
FACT
FBTSCAN
FORCE_XML_QUERY_REWRITE
GATHER_PLAN_STATISTICS
GBY_CONC_ROLLUP
GBY_PUSHDOWN
HWM_BROKERED
IGNORE_OPTIM_EMBEDDED_HINTS
IGNORE_WHERE_CLAUSE
INCLUDE_VERSION
INLINE
INLINE_XMLTYPE_NT
JOIN
LEADING
LIKE_EXPAND
LOCAL_INDEXES
MERGE
MERGE_CONST_ON
MODE
MODEL_COMPILE_SUBQUERY
MODEL_DONTVERIFY_UNIQUENESS
MODEL_DYNAMIC_SUBQUERY
MODEL_MIN_ANALYSIS
MODEL_PUSH_REF
MONITOR
MV_MERGE
NATIVE_FULL_OUTER_JOIN
NESTED_TABLE_FAST_INSERT
NESTED_TABLE_GET_REFS
NESTED_TABLE_SET_SETID
NO_ACCESS
NO_CARTESIAN
NO_CHECK_ACL_REWRITE
NO_COST_XML_QUERY_REWRITE
NO_DOMAIN_INDEX_FILTER
NO_INDEX
NO_INDEX_FFS
NO_INDEX_SS
NO_LOAD
NO_MONITORING
NO_ORDER_ROLLUPS
NO_PARTIAL_COMMIT
NO_PRUNE_GSETS
NO_QKN_BUFF
NO_QUERY_TRANSFORMATION
NO_SQL_TUNE
NO_STATS_GSETS
NO_USE_HASH
NO_USE_MERGE
NO_USE_NL
NO_XML_DML_REWRITE
OLD_PUSH_PRED
OPAQUE_TRANSFORM
OPAQUE_XCANONICAL
OPTIMIZER_FEATURES_ENABLE
OPT_ESTIMATE
OPT_PARAM
ORDERED
ORDERED_PREDICATES
OR_EXPAND
OUTER_JOIN_TO_INNER
OUTLINE
OUTLINE_LEAF
OVERFLOW_NOMOVE
PARALLEL_INDEX
PIV_GB
PIV_SSF
PLACE_GROUP_BY
PQ_DISTRIBUTE
PQ_MAP
PRECOMPUTE_SUBQUERY
PRESERVE_OID
PULL_PRED
PUSH_PRED
PUSH_SUBQ
PX_JOIN_FILTER
QB_NAME
RBO_OUTLINE
REF_CASCADE_CURSOR
REMOTE_MAPPED
RESTORE_AS_INTERVALS
RESTRICT_ALL_REF_CONS
RESULT_CACHE
REWRITE
SAVE_AS_INTERVALS
SCN_ASCENDING
SEMIJOIN
SEMIJOIN_DRIVER
SET_TO_JOIN
SHARED
SKIP_EXT_OPTIMIZER
SKIP_UNQ_UNUSABLE_IDX
SQLLDR
STAR
STAR_TRANSFORMATION
STREAMS
SUBQUERY_PRUNING
SWAP_JOIN_INPUTS
SYS_DL_CURSOR
SYS_PARALLEL_TXN
SYS_RID_ORDER
TABLE_STATS
TRACING
UNNEST
USE_ANTI
USE_CONCAT
USE_HASH_AGGREGATION
USE_INVISIBLE_INDEXES
USE_NL_WITH_INDEX
USE_SEMI
USE_TTT_FOR_GSETS
USE_WEAK_NAME_RESL
VECTOR_READ
VECTOR_READ_TRACE
XMLINDEX_REWRITE
XML_DML_RWT_STMT
X_DYN_PRUNE

148 rows selected.
 
  
SQL> select class, name, inverse from v$sql_hint
  2  order by class, name;
 
CLASS                          NAME                           INVERSE
------------------------------ ------------------------------ ------------------------------
ACCESS                         AND_EQUAL
ACCESS                         BITMAP_TREE
ACCESS                         CLUSTER
ACCESS                         FULL
ACCESS                         HASH
ACCESS                         INDEX                          NO_INDEX
ACCESS                         INDEX_ASC                      NO_INDEX
ACCESS                         INDEX_COMBINE
ACCESS                         INDEX_DESC                     NO_INDEX
ACCESS                         INDEX_FFS
ACCESS                         INDEX_JOIN
ACCESS                         INDEX_RRS
ACCESS                         INDEX_RS_ASC
ACCESS                         INDEX_RS_DESC
ACCESS                         INDEX_SS                       NO_INDEX_SS
ACCESS                         INDEX_SS_ASC                   NO_INDEX_SS
ACCESS                         INDEX_SS_DESC                  NO_INDEX_SS
ACCESS                         NLJ_BATCHING                   NO_NLJ_BATCHING
ACCESS                         NLJ_PREFETCH                   NO_NLJ_PREFETCH
ACCESS                         NO_NLJ_BATCHING                NLJ_BATCHING
ACCESS                         NO_NLJ_PREFETCH                NLJ_PREFETCH
ACCESS                         NUM_INDEX_KEYS
ACCESS                         QUEUE_CURR
ACCESS                         QUEUE_ROWP
ACCESS                         ROWID
ANTIJOIN                       ANTIJOIN
ANTIJOIN                       HASH_AJ
ANTIJOIN                       MERGE_AJ
ANTIJOIN                       NL_AJ
APPEND                         APPEND                         NOAPPEND
APPEND                         NOAPPEND                       APPEND
BITMAP                         BITMAP
BUFFER                         BUFFER                         NO_BUFFER
BUFFER                         NO_BUFFER                      BUFFER
BYPASS_RECURSIVE_CHECK         BYPASS_RECURSIVE_CHECK
BYPASS_UJVC                    BYPASS_UJVC
CACHE                          CACHE                          NOCACHE
CACHE                          CACHE_TEMP_TABLE               NOCACHE
CACHE                          NOCACHE                        CACHE
CACHE_CB                       CACHE_CB                       NOCACHE
CARDINALITY                    CARDINALITY
CHECK_ACL_REWRITE              CHECK_ACL_REWRITE              NO_CHECK_ACL_REWRITE
CONNECT_BY_COMBINE_SW          CONNECT_BY_COMBINE_SW          NO_CONNECT_BY_COMBINE_SW
CONNECT_BY_COMBINE_SW          NO_CONNECT_BY_COMBINE_SW       CONNECT_BY_COMBINE_SW
CONNECT_BY_COST_BASED          CONNECT_BY_COST_BASED          NO_CONNECT_BY_COST_BASED
CONNECT_BY_COST_BASED          NO_CONNECT_BY_COST_BASED       CONNECT_BY_COST_BASED
CONNECT_BY_FILTERING           CONNECT_BY_FILTERING           NO_CONNECT_BY_FILTERING
CONNECT_BY_FILTERING           NO_CONNECT_BY_FILTERING        CONNECT_BY_FILTERING
COST_XML_QUERY_REWRITE         COST_XML_QUERY_REWRITE         NO_COST_XML_QUERY_REWRITE
CPU_COSTING                    CPU_COSTING                    NO_CPU_COSTING
CPU_COSTING                    NO_CPU_COSTING                 CPU_COSTING
CUBE_GB                        CUBE_GB
CURSOR_SHARING_EXACT           CURSOR_SHARING_EXACT
DBMS_STATS                     DBMS_STATS
DB_VERSION                     DB_VERSION
DEREF_NO_REWRITE               DEREF_NO_REWRITE
DML_UPDATE                     DML_UPDATE
DOMAIN_INDEX_FILTER            DOMAIN_INDEX_FILTER            NO_DOMAIN_INDEX_FILTER
DOMAIN_INDEX_SORT              DOMAIN_INDEX_NO_SORT           DOMAIN_INDEX_SORT
DOMAIN_INDEX_SORT              DOMAIN_INDEX_SORT              DOMAIN_INDEX_NO_SORT
DRIVING_SITE                   DRIVING_SITE
DYNAMIC_SAMPLING               DYNAMIC_SAMPLING
DYNAMIC_SAMPLING_EST_CDN       DYNAMIC_SAMPLING_EST_CDN
ELIMINATE_JOIN                 ELIMINATE_JOIN                 NO_ELIMINATE_JOIN
ELIMINATE_JOIN                 NO_ELIMINATE_JOIN              ELIMINATE_JOIN
ELIMINATE_OBY                  ELIMINATE_OBY                  NO_ELIMINATE_OBY
ELIMINATE_OBY                  NO_ELIMINATE_OBY               ELIMINATE_OBY
EXPAND_GSET_TO_UNION           EXPAND_GSET_TO_UNION           NO_EXPAND_GSET_TO_UNION
EXPAND_GSET_TO_UNION           NO_EXPAND_GSET_TO_UNION        EXPAND_GSET_TO_UNION
EXPR_CORR_CHECK                EXPR_CORR_CHECK
FACT                           FACT                           NO_FACT
FACT                           NO_FACT                        FACT
FBTSCAN                        FBTSCAN
FORCE_XML_QUERY_REWRITE        FORCE_XML_QUERY_REWRITE        NO_XML_QUERY_REWRITE
FORCE_XML_QUERY_REWRITE        NO_XML_QUERY_REWRITE           FORCE_XML_QUERY_REWRITE
GATHER_PLAN_STATISTICS         GATHER_PLAN_STATISTICS
GBY_CONC_ROLLUP                GBY_CONC_ROLLUP
GBY_PUSHDOWN                   GBY_PUSHDOWN                   NO_GBY_PUSHDOWN
GBY_PUSHDOWN                   NO_GBY_PUSHDOWN                GBY_PUSHDOWN
HWM_BROKERED                   HWM_BROKERED
IGNORE_OPTIM_EMBEDDED_HINTS    IGNORE_OPTIM_EMBEDDED_HINTS
IGNORE_WHERE_CLAUSE            IGNORE_WHERE_CLAUSE
INCLUDE_VERSION                INCLUDE_VERSION
INLINE                         INLINE                         MATERIALIZE
INLINE                         MATERIALIZE                    INLINE
INLINE_XMLTYPE_NT              INLINE_XMLTYPE_NT
JOIN                           USE_HASH                       NO_USE_HASH
JOIN                           USE_MERGE                      NO_USE_MERGE
JOIN                           USE_MERGE_CARTESIAN
JOIN                           USE_NL                         NO_USE_NL
LEADING                        LEADING
LIKE_EXPAND                    LIKE_EXPAND
LOCAL_INDEXES                  LOCAL_INDEXES
MERGE                          MERGE                          NO_MERGE
MERGE                          NO_MERGE                       MERGE
MERGE_CONST_ON                 MERGE_CONST_ON
MODE                           ALL_ROWS
MODE                           CHOOSE
MODE                           FIRST_ROWS
MODE                           RULE
MODEL_COMPILE_SUBQUERY         MODEL_COMPILE_SUBQUERY
MODEL_DONTVERIFY_UNIQUENESS    MODEL_DONTVERIFY_UNIQUENESS
MODEL_DYNAMIC_SUBQUERY         MODEL_DYNAMIC_SUBQUERY
MODEL_MIN_ANALYSIS             MODEL_MIN_ANALYSIS
MODEL_MIN_ANALYSIS             MODEL_NO_ANALYSIS
MODEL_PUSH_REF                 MODEL_PUSH_REF                 NO_MODEL_PUSH_REF
MODEL_PUSH_REF                 NO_MODEL_PUSH_REF              MODEL_PUSH_REF
MONITOR                        MONITOR                        NO_MONITOR
MONITOR                        NO_MONITOR                     MONITOR
MV_MERGE                       MV_MERGE
NATIVE_FULL_OUTER_JOIN         NATIVE_FULL_OUTER_JOIN         NO_NATIVE_FULL_OUTER_JOIN
NATIVE_FULL_OUTER_JOIN         NO_NATIVE_FULL_OUTER_JOIN      NATIVE_FULL_OUTER_JOIN
NESTED_TABLE_FAST_INSERT       NESTED_TABLE_FAST_INSERT
NESTED_TABLE_GET_REFS          NESTED_TABLE_GET_REFS
NESTED_TABLE_SET_SETID         NESTED_TABLE_SET_SETID
NO_ACCESS                      NO_ACCESS
NO_CARTESIAN                   NO_CARTESIAN
NO_CHECK_ACL_REWRITE           NO_CHECK_ACL_REWRITE           CHECK_ACL_REWRITE
NO_COST_XML_QUERY_REWRITE      NO_COST_XML_QUERY_REWRITE      COST_XML_QUERY_REWRITE
NO_DOMAIN_INDEX_FILTER         NO_DOMAIN_INDEX_FILTER         DOMAIN_INDEX_FILTER
NO_INDEX                       NO_INDEX                       INDEX
NO_INDEX_FFS                   NO_INDEX_FFS                   INDEX_FFS
NO_INDEX_SS                    NO_INDEX_SS                    INDEX_SS
NO_LOAD                        NO_LOAD
NO_MONITORING                  NO_MONITORING
NO_ORDER_ROLLUPS               NO_ORDER_ROLLUPS
NO_PARTIAL_COMMIT              NO_PARTIAL_COMMIT
NO_PRUNE_GSETS                 NO_PRUNE_GSETS
NO_QKN_BUFF                    NO_QKN_BUFF
NO_QUERY_TRANSFORMATION        NO_QUERY_TRANSFORMATION
NO_SQL_TUNE                    NO_SQL_TUNE
NO_STATS_GSETS                 NO_STATS_GSETS
NO_USE_HASH                    NO_USE_HASH                    USE_HASH
NO_USE_MERGE                   NO_USE_MERGE                   USE_MERGE
NO_USE_NL                      NO_USE_NL                      USE_NL
NO_XML_DML_REWRITE             NO_XML_DML_REWRITE
OLD_PUSH_PRED                  OLD_PUSH_PRED
OPAQUE_TRANSFORM               OPAQUE_TRANSFORM
OPAQUE_XCANONICAL              OPAQUE_XCANONICAL
OPTIMIZER_FEATURES_ENABLE      OPTIMIZER_FEATURES_ENABLE
OPT_ESTIMATE                   OPT_ESTIMATE
OPT_PARAM                      OPT_PARAM
ORDERED                        ORDERED
ORDERED_PREDICATES             ORDERED_PREDICATES
OR_EXPAND                      OR_EXPAND
OUTER_JOIN_TO_INNER            NO_OUTER_JOIN_TO_INNER         OUTER_JOIN_TO_INNER
OUTER_JOIN_TO_INNER            OUTER_JOIN_TO_INNER            NO_OUTER_JOIN_TO_INNER
OUTLINE                        OUTLINE
OUTLINE_LEAF                   OUTLINE_LEAF
OVERFLOW_NOMOVE                OVERFLOW_NOMOVE
PARALLEL_INDEX                 NO_PARALLEL_INDEX              PARALLEL_INDEX
PARALLEL_INDEX                 PARALLEL_INDEX                 NO_PARALLEL_INDEX
PIV_GB                         PIV_GB
PIV_GB                         TIV_GB
PIV_SSF                        PIV_SSF
PIV_SSF                        TIV_SSF
PLACE_GROUP_BY                 NO_PLACE_GROUP_BY              PLACE_GROUP_BY
PLACE_GROUP_BY                 PLACE_GROUP_BY                 NO_PLACE_GROUP_BY
PQ_DISTRIBUTE                  PQ_DISTRIBUTE
PQ_MAP                         PQ_MAP                         PQ_NOMAP
PQ_MAP                         PQ_NOMAP                       PQ_MAP
PRECOMPUTE_SUBQUERY            PRECOMPUTE_SUBQUERY
PRESERVE_OID                   PRESERVE_OID
PULL_PRED                      NO_PULL_PRED                   PULL_PRED
PULL_PRED                      PULL_PRED                      NO_PULL_PRED
PUSH_PRED                      NO_PUSH_PRED                   PUSH_PRED
PUSH_PRED                      PUSH_PRED                      NO_PUSH_PRED
PUSH_SUBQ                      NO_PUSH_SUBQ                   PUSH_SUBQ
PUSH_SUBQ                      PUSH_SUBQ                      NO_PUSH_SUBQ
PX_JOIN_FILTER                 NO_PX_JOIN_FILTER              PX_JOIN_FILTER
PX_JOIN_FILTER                 PX_JOIN_FILTER                 NO_PX_JOIN_FILTER
QB_NAME                        QB_NAME
RBO_OUTLINE                    RBO_OUTLINE
REF_CASCADE_CURSOR             NO_REF_CASCADE                 REF_CASCADE_CURSOR
REF_CASCADE_CURSOR             REF_CASCADE_CURSOR             NO_REF_CASCADE
REMOTE_MAPPED                  REMOTE_MAPPED
RESTORE_AS_INTERVALS           RESTORE_AS_INTERVALS
RESTRICT_ALL_REF_CONS          RESTRICT_ALL_REF_CONS
RESULT_CACHE                   NO_RESULT_CACHE                RESULT_CACHE
RESULT_CACHE                   RESULT_CACHE                   NO_RESULT_CACHE
REWRITE                        NO_BASETABLE_MULTIMV_REWRITE   REWRITE
REWRITE                        NO_MULTIMV_REWRITE             REWRITE
REWRITE                        NO_REWRITE                     REWRITE
REWRITE                        REWRITE                        NO_REWRITE
REWRITE                        REWRITE_OR_ERROR
SAVE_AS_INTERVALS              SAVE_AS_INTERVALS
SCN_ASCENDING                  SCN_ASCENDING
SEMIJOIN                       HASH_SJ
SEMIJOIN                       MERGE_SJ
SEMIJOIN                       NL_SJ
SEMIJOIN                       NO_SEMIJOIN                    SEMIJOIN
SEMIJOIN                       SEMIJOIN                       NO_SEMIJOIN
SEMIJOIN_DRIVER                SEMIJOIN_DRIVER
SET_TO_JOIN                    NO_SET_TO_JOIN                 SET_TO_JOIN
SET_TO_JOIN                    SET_TO_JOIN                    NO_SET_TO_JOIN
SHARED                         NOPARALLEL                     SHARED
SHARED                         NO_PARALLEL                    SHARED
SHARED                         SHARED                         NO_PARALLEL
SKIP_EXT_OPTIMIZER             SKIP_EXT_OPTIMIZER
SKIP_UNQ_UNUSABLE_IDX          SKIP_UNQ_UNUSABLE_IDX
SQLLDR                         SQLLDR
STAR                           STAR
STAR_TRANSFORMATION            NO_STAR_TRANSFORMATION         STAR_TRANSFORMATION
STAR_TRANSFORMATION            STAR_TRANSFORMATION            NO_STAR_TRANSFORMATION
STREAMS                        STREAMS
SUBQUERY_PRUNING               NO_SUBQUERY_PRUNING            SUBQUERY_PRUNING
SUBQUERY_PRUNING               SUBQUERY_PRUNING               NO_SUBQUERY_PRUNING
SWAP_JOIN_INPUTS               NO_SWAP_JOIN_INPUTS            SWAP_JOIN_INPUTS
SWAP_JOIN_INPUTS               SWAP_JOIN_INPUTS               NO_SWAP_JOIN_INPUTS
SYS_DL_CURSOR                  SYS_DL_CURSOR
SYS_PARALLEL_TXN               SYS_PARALLEL_TXN
SYS_RID_ORDER                  SYS_RID_ORDER
TABLE_STATS                    COLUMN_STATS
TABLE_STATS                    INDEX_STATS
TABLE_STATS                    TABLE_STATS
TRACING                        TRACING
UNNEST                         NO_UNNEST                      UNNEST
UNNEST                         UNNEST                         NO_UNNEST
USE_ANTI                       USE_ANTI
USE_CONCAT                     NO_EXPAND                      USE_CONCAT
USE_CONCAT                     USE_CONCAT                     NO_EXPAND
USE_HASH_AGGREGATION           NO_USE_HASH_AGGREGATION        USE_HASH_AGGREGATION
USE_HASH_AGGREGATION           USE_HASH_AGGREGATION           NO_USE_HASH_AGGREGATION
USE_INVISIBLE_INDEXES          USE_INVISIBLE_INDEXES
USE_NL_WITH_INDEX              USE_NL_WITH_INDEX              NO_USE_NL
USE_SEMI                       USE_SEMI
USE_TTT_FOR_GSETS              USE_TTT_FOR_GSETS
USE_WEAK_NAME_RESL             USE_WEAK_NAME_RESL
VECTOR_READ                    VECTOR_READ
VECTOR_READ_TRACE              VECTOR_READ_TRACE
XMLINDEX_REWRITE               NO_XMLINDEX_REWRITE            XMLINDEX_REWRITE
XMLINDEX_REWRITE               NO_XMLINDEX_REWRITE_IN_SELECT  XMLINDEX_REWRITE_IN_SELECT
XMLINDEX_REWRITE               XMLINDEX_REWRITE               NO_XMLINDEX_REWRITE
XMLINDEX_REWRITE               XMLINDEX_REWRITE_IN_SELECT     NO_XMLINDEX_REWRITE_IN_SELECT
XML_DML_RWT_STMT               XML_DML_RWT_STMT
X_DYN_PRUNE                    X_DYN_PRUNE
 
236 rows selected.
SQL> select name, version from v$sql_hint order by name, version;
 
NAME                                                             VERSION
---------------------------------------------------------------- -------------------------
ALL_ROWS                                                         8.1.0
AND_EQUAL                                                        8.1.0
ANTIJOIN                                                         9.0.0
APPEND                                                           8.1.0
BITMAP                                                           8.1.0
BITMAP_TREE                                                      10.2.0.1
BUFFER                                                           8.1.5
BYPASS_RECURSIVE_CHECK                                           9.0.0
BYPASS_UJVC                                                      8.1.5
CACHE                                                            8.1.0
CACHE_CB                                                         8.1.5
CACHE_TEMP_TABLE                                                 8.1.5
CARDINALITY                                                      9.0.0
CHECK_ACL_REWRITE                                                11.1.0.6
CHOOSE                                                           8.1.0
CLUSTER                                                          8.0.0
COLUMN_STATS                                                     10.1.0.3
CONNECT_BY_COMBINE_SW                                            10.1.0.6
CONNECT_BY_COST_BASED                                            10.2.0.2
CONNECT_BY_FILTERING                                             10.2.0.2
COST_XML_QUERY_REWRITE                                           11.1.0.6
CPU_COSTING                                                      9.0.0
CUBE_GB                                                          8.1.5
CURSOR_SHARING_EXACT                                             9.0.0
DBMS_STATS                                                       10.2.0.1
DB_VERSION                                                       11.1.0.6
DEREF_NO_REWRITE                                                 8.1.0
DML_UPDATE                                                       9.0.0
DOMAIN_INDEX_FILTER                                              11.1.0.6
DOMAIN_INDEX_NO_SORT                                             8.1.5
DOMAIN_INDEX_SORT                                                8.1.5
DRIVING_SITE                                                     8.1.0
DYNAMIC_SAMPLING                                                 9.2.0
DYNAMIC_SAMPLING_EST_CDN                                         9.2.0
ELIMINATE_JOIN                                                   10.2.0.1
ELIMINATE_OBY                                                    10.2.0.1
EXPAND_GSET_TO_UNION                                             9.2.0
EXPR_CORR_CHECK                                                  8.0.0
FACT                                                             8.1.0
FBTSCAN                                                          10.1.0.3
FIRST_ROWS                                                       8.1.0
FORCE_XML_QUERY_REWRITE                                          9.2.0
FULL                                                             8.1.0
GATHER_PLAN_STATISTICS                                           10.1.0.3
GBY_CONC_ROLLUP                                                  9.0.0
GBY_PUSHDOWN                                                     11.1.0.6
HASH                                                             8.1.0
HASH_AJ                                                          8.1.0
HASH_SJ                                                          8.1.0
HWM_BROKERED                                                     9.0.0
IGNORE_OPTIM_EMBEDDED_HINTS                                      10.1.0.3
IGNORE_WHERE_CLAUSE                                              9.2.0
INCLUDE_VERSION                                                  10.1.0.3
INDEX                                                            8.0.0
INDEX_ASC                                                        8.1.0
INDEX_COMBINE                                                    8.1.0
INDEX_DESC                                                       8.1.0
INDEX_FFS                                                        8.1.0
INDEX_JOIN                                                       8.1.5
INDEX_RRS                                                        9.0.0
INDEX_RS_ASC                                                     10.1.0.6
INDEX_RS_DESC                                                    10.1.0.6
INDEX_SS                                                         9.0.0
INDEX_SS_ASC                                                     9.0.0
INDEX_SS_DESC                                                    9.0.0
INDEX_STATS                                                      10.1.0.3
INLINE                                                           9.0.0
INLINE_XMLTYPE_NT                                                10.2.0.1
LEADING                                                          8.1.6
LIKE_EXPAND                                                      8.1.7
LOCAL_INDEXES                                                    9.0.0
MATERIALIZE                                                      9.0.0
MERGE                                                            8.1.0
MERGE_AJ                                                         8.1.0
MERGE_CONST_ON                                                   8.0.0
MERGE_SJ                                                         8.1.0
MODEL_COMPILE_SUBQUERY                                           10.2.0.1
MODEL_DONTVERIFY_UNIQUENESS                                      10.1.0.3
MODEL_DYNAMIC_SUBQUERY                                           10.2.0.1
MODEL_MIN_ANALYSIS                                               10.1.0.3
MODEL_NO_ANALYSIS                                                10.1.0.3
MODEL_PUSH_REF                                                   10.1.0.3
MONITOR                                                          11.1.0.6
MV_MERGE                                                         9.0.0
NATIVE_FULL_OUTER_JOIN                                           10.2.0.3
NESTED_TABLE_FAST_INSERT                                         10.1.0.3
NESTED_TABLE_GET_REFS                                            8.1.0
NESTED_TABLE_SET_SETID                                           8.1.5
NLJ_BATCHING                                                     11.1.0.6
NLJ_PREFETCH                                                     11.1.0.6
NL_AJ                                                            8.0.0
NL_SJ                                                            8.0.0
NOAPPEND                                                         8.1.0
NOCACHE                                                          8.1.0
NOPARALLEL                                                       8.1.0
NO_ACCESS                                                        8.1.5
NO_BASETABLE_MULTIMV_REWRITE                                     10.1.0.3
NO_BUFFER                                                        8.1.5
NO_CARTESIAN                                                     10.2.0.1
NO_CHECK_ACL_REWRITE                                             11.1.0.6
NO_CONNECT_BY_COMBINE_SW                                         10.1.0.6
NO_CONNECT_BY_COST_BASED                                         10.2.0.2
NO_CONNECT_BY_FILTERING                                          10.2.0.2
NO_COST_XML_QUERY_REWRITE                                        11.1.0.6
NO_CPU_COSTING                                                   9.0.0
NO_DOMAIN_INDEX_FILTER                                           11.1.0.6
NO_ELIMINATE_JOIN                                                10.2.0.1
NO_ELIMINATE_OBY                                                 10.2.0.1
NO_EXPAND                                                        8.1.0
NO_EXPAND_GSET_TO_UNION                                          9.2.0
NO_FACT                                                          8.1.0
NO_GBY_PUSHDOWN                                                  11.1.0.6
NO_INDEX                                                         8.1.5
NO_INDEX_FFS                                                     10.1.0.3
NO_INDEX_SS                                                      10.1.0.3
NO_LOAD                                                          11.1.0.6
NO_MERGE                                                         8.0.0
NO_MODEL_PUSH_REF                                                10.1.0.3
NO_MONITOR                                                       11.1.0.6
NO_MONITORING                                                    8.0.0
NO_MULTIMV_REWRITE                                               10.1.0.3
NO_NATIVE_FULL_OUTER_JOIN                                        10.2.0.3
NO_NLJ_BATCHING                                                  11.1.0.6
NO_NLJ_PREFETCH                                                  11.1.0.6
NO_ORDER_ROLLUPS                                                 8.0.0
NO_OUTER_JOIN_TO_INNER                                           11.1.0.6
NO_PARALLEL                                                      10.1.0.3
NO_PARALLEL_INDEX                                                8.1.0
NO_PARTIAL_COMMIT                                                10.1.0.3
NO_PLACE_GROUP_BY                                                11.1.0.6
NO_PRUNE_GSETS                                                   9.0.0
NO_PULL_PRED                                                     10.2.0.1
NO_PUSH_PRED                                                     8.1.0
NO_PUSH_SUBQ                                                     9.2.0
NO_PX_JOIN_FILTER                                                10.2.0.1
NO_QKN_BUFF                                                      9.2.0
NO_QUERY_TRANSFORMATION                                          10.1.0.3
NO_REF_CASCADE                                                   9.2.0
NO_RESULT_CACHE                                                  11.1.0.6
NO_REWRITE                                                       8.1.5
NO_SEMIJOIN                                                      9.0.0
NO_SET_TO_JOIN                                                   10.1.0.3
NO_SQL_TUNE                                                      10.2.0.1
NO_STAR_TRANSFORMATION                                           10.1.0.3
NO_STATS_GSETS                                                   8.0.0
NO_SUBQUERY_PRUNING                                              11.1.0.6
NO_SWAP_JOIN_INPUTS                                              10.1.0.3
NO_UNNEST                                                        8.1.6
NO_USE_HASH                                                      10.1.0.3
NO_USE_HASH_AGGREGATION                                          10.2.0.1
NO_USE_MERGE                                                     10.1.0.3
NO_USE_NL                                                        10.1.0.3
NO_XMLINDEX_REWRITE                                              11.1.0.6
NO_XMLINDEX_REWRITE_IN_SELECT                                    11.1.0.6
NO_XML_DML_REWRITE                                               10.2.0.1
NO_XML_QUERY_REWRITE                                             9.2.0
NUM_INDEX_KEYS                                                   10.2.0.3
OLD_PUSH_PRED                                                    10.2.0.1
OPAQUE_TRANSFORM                                                 10.1.0.3
OPAQUE_XCANONICAL                                                10.1.0.3
OPTIMIZER_FEATURES_ENABLE                                        10.1.0.3
OPT_ESTIMATE                                                     10.1.0.3
OPT_PARAM                                                        10.2.0.1
ORDERED                                                          8.1.0
ORDERED_PREDICATES                                               8.0.0
OR_EXPAND                                                        8.1.7
OUTER_JOIN_TO_INNER                                              11.1.0.6
OUTLINE                                                          10.2.0.1
OUTLINE_LEAF                                                     10.2.0.1
OVERFLOW_NOMOVE                                                  9.0.0
PARALLEL_INDEX                                                   8.1.0
PIV_GB                                                           8.1.0
PIV_SSF                                                          8.1.0
PLACE_GROUP_BY                                                   11.1.0.6
PQ_DISTRIBUTE                                                    8.1.5
PQ_MAP                                                           9.0.0
PQ_NOMAP                                                         9.0.0
PRECOMPUTE_SUBQUERY                                              10.2.0.1
PRESERVE_OID                                                     10.2.0.1
PULL_PRED                                                        10.2.0.1
PUSH_PRED                                                        8.1.0
PUSH_SUBQ                                                        8.1.0
PX_JOIN_FILTER                                                   10.2.0.1
QB_NAME                                                          10.1.0.3
QUEUE_CURR                                                       8.0.0
QUEUE_ROWP                                                       8.0.0
RBO_OUTLINE                                                      10.2.0.1
REF_CASCADE_CURSOR                                               9.2.0
REMOTE_MAPPED                                                    8.1.0
RESTORE_AS_INTERVALS                                             8.1.5
RESTRICT_ALL_REF_CONS                                            10.1.0.3
RESULT_CACHE                                                     11.1.0.6
REWRITE                                                          8.1.5
REWRITE_OR_ERROR                                                 10.1.0.3
ROWID                                                            8.0.0
RULE                                                             8.1.0
SAVE_AS_INTERVALS                                                8.1.5
SCN_ASCENDING                                                    8.1.5
SEMIJOIN                                                         9.0.0
SEMIJOIN_DRIVER                                                  8.1.0
SET_TO_JOIN                                                      10.1.0.3
SHARED                                                           8.1.0
SKIP_EXT_OPTIMIZER                                               9.0.0
SKIP_UNQ_UNUSABLE_IDX                                            10.1.0.3
SQLLDR                                                           9.0.0
STAR                                                             8.1.0
STAR_TRANSFORMATION                                              8.1.0
STREAMS                                                          10.1.0.3
SUBQUERY_PRUNING                                                 11.1.0.6
SWAP_JOIN_INPUTS                                                 8.1.0
SYS_DL_CURSOR                                                    9.2.0
SYS_PARALLEL_TXN                                                 8.1.6
SYS_RID_ORDER                                                    9.2.0
TABLE_STATS                                                      10.1.0.3
TIV_GB                                                           8.1.0
TIV_SSF                                                          8.1.0
TRACING                                                          10.1.0.3
UNNEST                                                           8.1.6
USE_ANTI                                                         8.1.0
USE_CONCAT                                                       8.1.0
USE_HASH                                                         8.1.0
USE_HASH_AGGREGATION                                             10.2.0.1
USE_INVISIBLE_INDEXES                                            11.1.0.6
USE_MERGE                                                        8.1.0
USE_MERGE_CARTESIAN                                              11.1.0.6
USE_NL                                                           8.1.0
USE_NL_WITH_INDEX                                                10.1.0.3
USE_SEMI                                                         8.1.0
USE_TTT_FOR_GSETS                                                9.0.0
USE_WEAK_NAME_RESL                                               10.1.0.3
VECTOR_READ                                                      10.1.0.3
VECTOR_READ_TRACE                                                10.1.0.3
XMLINDEX_REWRITE                                                 11.1.0.6
XMLINDEX_REWRITE_IN_SELECT                                       11.1.0.6
XML_DML_RWT_STMT                                                 11.1.0.6
X_DYN_PRUNE                                                      10.1.0.3
 
236 rows selected.
 

 


 

 

��  
 
 
Oracle Training at Sea
 
 
 
 
oracle dba poster
 

 
Follow us on Twitter 
 
Oracle performance tuning software 
 
Oracle Linux poster
 
 
 

 

Burleson is the American Team

Note: This Oracle documentation was created as a support and Oracle training reference for use by our DBA performance tuning consulting professionals.  Feel free to ask questions on our Oracle forum.

Verify experience! Anyone considering using the services of an Oracle support expert should independently investigate their credentials and experience, and not rely on advertisements and self-proclaimed expertise. All legitimate Oracle experts publish their Oracle qualifications.

Errata?  Oracle technology is changing and we strive to update our BC Oracle support information.  If you find an error or have a suggestion for improving our content, we would appreciate your feedback.  Just  e-mail:  

and include the URL for the page.


                    









Burleson Consulting

The Oracle of Database Support

Oracle Performance Tuning

Remote DBA Services


 

Copyright © 1996 -  2020

All rights reserved by Burleson

Oracle ® is the registered trademark of Oracle Corporation.