“SQL plan management is a preventative mechanism that enables the optimizer to automatically manage execution plans, ensuring that the database uses only known or verified plans.”
SPM has three main components:
• Plan Capture: OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES = TRUE (Automatic Initial Plan Capture), OPTIMIZER_USE_SQL_PLAN_BASELINE=TRUE
• Plan Selection
• Plan Verification/Evolution
dba_sql_plan_baselines
DBA_SQL_PLAN_BASELINE
Database Administration -> Database SQL Tuning Guide -> 23 Managing SQL Plan Baselines
*The views expressed here are my own and do not represent those of my employer.*
Hello, I’m Bruno — a dual citizen of Brazil and Sweden. I bring a global perspective shaped by experiences in both South America and Europe, with a strong focus on collaboration and innovation across cultures. I am a Computer Scientist, PhD Candidate in Information and Communication Technologies, focusing on Data Science and Artificial Intelligence, and hold dual Master’s degrees in Data Science and Cybersecurity. With over fifteen years of international experience spanning Brazil, Hungary, and Sweden, I have collaborated with global organizations such as IBM, Playtech, and Oracle, as well as contributed remotely to projects across multiple regions. My professional interests include Databases, Cybersecurity, Cloud Computing, Data Science, Data Engineering, Big Data, Artificial Intelligence, Programming, and Software Engineering, all driven by a deep passion for transforming data into strategic business value.
… [Trackback]
[…] Read More Information here to that Topic: techdatabasket.com/2019/03/21/ocm-12c-managing-sql-plan-baselines/ […]
… [Trackback]
[…] Find More here to that Topic: techdatabasket.com/2019/03/21/ocm-12c-managing-sql-plan-baselines/ […]
… [Trackback]
[…] Read More to that Topic: techdatabasket.com/2019/03/21/ocm-12c-managing-sql-plan-baselines/ […]
… [Trackback]
[…] Read More here to that Topic: techdatabasket.com/2019/03/21/ocm-12c-managing-sql-plan-baselines/ […]
… [Trackback]
[…] Read More on on that Topic: techdatabasket.com/2019/03/21/ocm-12c-managing-sql-plan-baselines/ […]