Abstract:
Oracle Diagnostics and Tuning packs offer comprehensive valuable performance diagnostics and tuning features such as: AWR, ADDM, ASH, ASH Analytics, etc. These optional packs can be licensed only on top of the Oracle Enterprise Edition. Without these packs, diagnosing performance issues may become a very complex task – even for advanced DBAs. In this session we will explore how you could leverage Oracle’s Statspack report and dictionary views to diagnose performance issues even without using any expensive editions and packs. In addition we will see how Quest tools can help DBAs to diagnose and solve even the most complex performance issues without relying on the Diagnostics and Tuning packs and for all the Oracle Database editions.
Slide Deck:
Slide deck is also available (https://www.slideshare.net/PiniDibask/winning-performance-challenges-in-oracle-standard-editions)
I'd like to thank everyone who attended and if you have any follow-up questions feel free to contact me (Pini.Dibask@Quest.com).
