Refresh?
David D., September 18, 2020 - 8:43 am UTC
Hello Chris,
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."
Best regards,
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
Narendra, September 18, 2020 - 6:20 pm UTC
Hello Chris,
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
David Dubois, September 20, 2020 - 6:40 pm UTC
Hi Chris,
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"..
David D.
A reader, September 29, 2020 - 7:36 am UTC