DX Operational Intelligence

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

03-15-2016 01:20 PM

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.

Statistics
0 Favorited
2 Views
0 Files
0 Shares
0 Downloads

Tags and Keywords

Comments

03-17-2016 07:32 AM

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

Related Entries and Links

No Related Resource entered.