Tech Tip: Rollups taking an increasing amount of time to complete daily?

Document created by Mohindra.Singh Employee on Mar 15, 2016Last modified by Melissa Potvin on Mar 28, 2016
Version 2Show Document
  • View in full screen mode

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.

Attachments

    Outcomes