Loading Hinted Execution Plans into SQL Plan Baseline.
(Doc ID 787692.1)
Last updated on APRIL 10, 2023
Applies to:
Oracle Database Exadata Express Cloud Service - Version N/A and laterOracle Database - Enterprise Edition - Version 11.1.0.6 and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Information in this document applies to any platform.
Goal
This document will show the user how to create SQL Plan Baselines for
- SQL coming from an application where the SQL can't be modified
- SQL need hints to run a good execution plan
Please note that PLAN_HASH_VALUE is different than HASH_VALUE for the SQL
In the following section , PLAN_HASH_VALUE is only used and not HASH_VALUE
Solution
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Goal |
Solution |
References |