반응형

DBMS의 parameter 를 아래와 같이 변경하여 적용을 하였습니다.

1. optimizer_adaptive_plans : TRUE -> FALSE

2. optimizer_adaptive_reporting_only : FALSE -> TRUE

3. db_cache_size : default(0) -> '5G~15G'

https://smarttechways.com/2020/08/08/optimizer-adaptive-feature-parameter-in-oracle/

 https://haisins.synology.me/wordpress/?p=4597 

https://aozjffl.tistory.com/1762

 

Optimizer Adaptive feature parameter in Oracle

Optimizer Adaptive feature parameter in Oracle   Oracle optimizer is used to find the most effective execution plan for each SQL statement. Oracle released adaptive feature in Oracle 12c. Adaptive …

smarttechways.com

감사합니다. 

반응형