这个问题是工作中常用的,也是面试的时候经常考察的问题。下面一些链接比较好: It’s possible to have both SQL Profiles and SQL Plan Baselines. SQL PROFILES : Adjust Optimizer cardinality estimations SPM BASELINES : Direct SQL to follow specific execution plan Researh on SQL Profiles and SQL Plan Baselines What is the difference between SQL Profiles and SQL Plan Baselines? (June 17, 2017) Nice table comparision between SQL Profiles and Plan Baselines https://sateeshv-dbainfo.blogspot.com/2017/06/what-is-difference-between-sql-profiles.html What is the difference between SQL Profiles and SQL Plan Baselines? https://blogs.oracle.com/optimizer/what-is-the-difference-between-sql-profiles-and-sql-plan-baselines Using SQL Plan Management to Control SQL Execution Plans https://blogs.oracle.com/optimizer/using-sql-plan-management-to-control-sql-execution-plans SQL Plan Management (Part 1 of 4) Creating SQL plan baselines https://blogs.oracle.com/optimizer/sql-plan-management-part-1-of-4-creating-sql-plan-baselines SQL Plan Management (Part 2 of 4) SPM Aware Optimizer https://blogs.oracle.com/optimizer/sql-plan-management-part-2-of-4-spm-aware-optimizer SQL Plan Management (Part 3 of 4): Evolving SQL Plan Baselines https://blogs.oracle.com/optimizer/sql-plan-management-part-3-of-4:-evolving-sql-plan-baselines SQL Plan Management (Part 4 of 4): User Interfaces and Other Features (February 2, 2009) https://blogs.oracle.com/optimizer/sql-plan-management-part-4-of-4:-user-interfaces-and-other-features New SQL Plan Management White Paper (January 30, 2017) https://blogs.oracle.com/optimizer/new-sql-plan-management-white-paper Upgrade to Oracle Database 12c and Avoid Query Regression (December 3, 2015) https://blogs.oracle.com/optimizer/upgrade-to-oracle-database-12c-and-avoid-query-regression Repairing SQL Performance Regression with SQL Plan Management (October 15, 2019) https://blogs.oracle.com/optimizer/repairing-sql-performance-regression-with-sql-plan-management
一个SQL Tuning的实战例子: https://blog.yannickjaquier.com/oracle/dbms_sqltune-concrete-example.html