The Tuning Process Using AWR and Custom Tools
-
Posted by Quest Customer Learning Team
- Last updated 4/13/21
- Share
Presented at INSYNC 21
Session ID: 100750
Many developers/DBA’s are challenged by the limitations of the standard AWR tools. Develop insight and command skill in the right application of the AWR toolset – or risk being drowned in the sea of performance metrics. To handle the many varied cases where it is necessary to go beyond the standard toolset, the Oracle DB tuner must be able to creatively query the historic performance metrics and quickly discern root causes and provide solutions.
Get a jump start by experiencing the presenter’s process and tools, along with some case studies of real-life performance nightmares that were converted into success stories. Learn where to look in the AWR data to solve the difficult performance problems. See the solutions and learn how to apply a results-producing strategy for digging deep in the AWR repository to power past your own specific performance issues. Additionally, the author will share his various scripts and SQL queries used to make the most effective use of AWR.
Watch the full-length video
You’ve reached the ultimate Oracle customer network—exclusively for Quest Corporate and Professional members.
Join Quest to unlock access to strategic content centers, event replays, exclusive programming, and expert insights—all designed to help Oracle users like you go further, faster.
Whether you're on JD Edwards, PeopleSoft, or Oracle Cloud, Quest connects you with a powerful peer network and Oracle experts so you can make smarter decisions, drive innovation, and get more from your investment.
Quest is where Oracle customers connect, learn, and lead with confidence. Ready to join them?
