오라클 19c 힌트 목록 확인 쿼리

OS환경 : Oracle Linux 7.6 (64bit)

 

DB 환경 : Oracle Database 19.3.0.0

 

방법 : 오라클 19c 힌트 목록 확인 쿼리

오라클에서 사용가능한 힌트 목록 확인 쿼리

SQL>
set lines 200 pages 1000
col name for a40
col class for a30
col inverse for a30
select name, substr(sql_feature,7) class, inverse, version, version_outline, target_level,
decode(bitand(target_level, 1), 0, 'no', 'yes') statement_level,
decode(bitand(target_level, 2), 0, 'no', 'yes') query_block_level,
decode(bitand(target_level, 4), 0, 'no', 'yes') object_level,
decode(bitand(target_level, 8), 0, 'no', 'yes') join_level
from v$sql_hint h
order by sql_feature, name;
 
NAME                                     CLASS                          INVERSE                        VERSION                   VERSION_OUTLINE           TARGET_LEVEL STA QUE OBJ JOI
---------------------------------------- ------------------------------ ------------------------------ ------------------------- ------------------------- ------------ --- --- --- ---
ADAPTIVE_PLAN                            ADAPTIVE_PLAN                  NO_ADAPTIVE_PLAN               12.1.0.2                  12.1.0.2                             1 yes no  no  no
NO_ADAPTIVE_PLAN                         ADAPTIVE_PLAN                  ADAPTIVE_PLAN                  12.1.0.2                  12.1.0.2                             1 yes no  no  no
BYPASS_RECURSIVE_CHECK                   ALL                                                           9.0.0                                                          2 no  yes no  no
CONNECT_BY_COMBINE_SW                    ALL                            NO_CONNECT_BY_COMBINE_SW       10.2.0.4                  10.2.0.4                             2 no  yes no  no
.
.

 

 

참조 : 

https://orasql.org/2019/05/28/vsql_hint-target_level/

http://www.koreaoug.org/tuning/7466