Loading Hinted Execution Plans into SQL Plan Baseline.
(Doc ID 787692.1)
Last updated on FEBRUARY 25, 2021
Applies to:Oracle Database - Enterprise Edition - Version 188.8.131.52 to 184.108.40.206.0 [Release 11.1 to 18]
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.
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
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