Part IX SQL Management Objects
A SQL management object is a feature that stabilizes the execution plans of individual SQL statements. SQL profiles and SQL plan baselines are SQL management objects.
This part contains the following chapters:
- Managing SQL Profiles
When warranted, SQL Tuning Advisor recommends a SQL profile. You can useDBMS_SQLTUNE
to implement, alter, drop, and transport SQL profiles. - Overview of SQL Plan Management
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. - Managing SQL Plan Baselines
This chapter explains the concepts and tasks relating to SQL plan management using theDBMS_SPM
package. - Migrating Stored Outlines to SQL Plan Baselines
Stored outline migration is the user-initiated process of converting stored outlines to SQL plan baselines. A SQL plan baseline is a set of plans proven to provide optimal performance.