September 18, 2020 - 8:43 am UTC
Reviewer: David D. from Paris-FRANCE
How can you refresh a SQL Profile?
In the doc I read : https://docs.oracle.com/database/121/TGSQL/tgsql_profiles.htm#TGSQL599
"If either the optimizer environment or SQL profile changes, then the optimizer can create a new plan. As tables grow, or as indexes are created or dropped, the plan for a SQL profile can change. The profile continues to be relevant even if the data distribution or access path of the corresponding statement changes. In general, you do not need to refresh SQL profiles."
David D. from Paris-FRANCE
September 18, 2020 - 3:29 pm UTC
I don't think there is a way to "refresh" it as such - you create a new one and drop the existing.
sql profile opt_estimate hints
September 18, 2020 - 6:20 pm UTC
Reviewer: Narendra from UK
When we run SQL Tuning Advisor for a specific sql id and it recommends a sql profile, the sql profile contains a set of OPT_ESTIMATE hints.
Is there a way to generate a set of OPT_ESTIMATE hints for any of the existing execution plans of a sql?
Thanks in advance
September 20, 2020 - 6:40 pm UTC
Reviewer: David Dubois from France
You say "you create a new one and drop the existing." : I am very surprised because I thought it was impossible for a human to create a SQL Profile; I thought it was only the SQL Tuning Advisor that were able to create one, based on its internal algorithm but we cannot say to it : "Create a SQL Profile" but "Enfance this SQL order and find a solution"..
September 29, 2020 - 7:36 am UTC
Reviewer: A reader