Tag: Performance-Tuning

Nov 13 @  2:00pm

Imagine being able to prove a performance problem is not a database issue. There are few ways to infer the problem resides elsewhere, but it's difficult for people to believe you. However, by creatively using ASH data and the idle wait event "SQL*Net message from client" we can do this. In this presentation, I will…

Original Broadcast: September 20, 2017 Be a hero with your DBA! Learn how to identify database key performance indicators, classify relevant workloads, and analyze AWR/STATSPACK reports to make meaningful recommendations for what is needed in your database system infrastructure to meet your performance service-level objectives. The methods discussed will apply equally to on-premises and cloud based infrastructure.…

The session covers lessons learned, tips/tricks, recommendations, best practices, gotchas and a whole lot more on how to effectively use Oracle Enterprise Manager 12c Cloud Control for quick, easy & intuitive performance tuning of your Oracle Database Cloud. Come learn from the experts on how to effectively employ/deploy Oracle Enterprise Manager for tuning, trouble-shooting &…

Performance tuning can be complex. It's often hard to know which knob to turn or button to press that will give you the biggest performance boost. The presentation will detail 12 steps to quickly identify performance issues and fix them. Learning Objectives: 1. The participant will learn how to quickly fine tune a sql statement using…

Performance tuning can be complex. It's often hard to know which knob to turn or button to press that will give you the biggest performance boost. The presentation will detail 12 steps to quickly identify performance issues and fix them. Learning Objectives: 1. The participant will learn how to quickly fine tune a sql statement using…

Performance tuning can be complex. It's often hard to know which knob to turn or button to press that will give you the biggest performance boost. The presentation will detail 12 steps to quickly identify performance issues and fix them. Learning Objectives: 1. The participant will learn how to quickly fine tune a sql statement using…