Question:Are daily Rollups taking an increasing amount of time to complete?
Answer:
Run Oracle SQL Tuning Advisor to tune long running queries, then Implement SQL Tuning Advisor recommendations.Over time Oracle may choose inefficient or more expensive operations when executing queries. Running the Advisor will identify the queries and offer recommendations to improve them. Implementing the recommendations can also be performed while the application is in use.
Additional Information:For more details on how to configure or use SQL Tuning Advisor, please consult with Oracle Automatic SQL Tuning product documentation.
Hi Mohindra
Do you have an examples of the types of recommendations from Oracle Tuning Advisor that are not already encapsulated in the out-of-the-box CCC DB? Or even any that are in conflict with the OOTB settings?
Thanks,
Adrian