Tag: Database Performance Tuning

Access all 11 Quest Experience Week PeopleSoft session recordings. Purchase now.

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…

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. This technical session…

Have you ever been overwhelmed looking at an AWR report and not sure where to start?  I will show you the different types of AWR reports,  information that is contained within each section and how you can use it to tune and troubleshoot your database.  I will provide examples of how I've used the reports…

Learn how to use simple algorithm analysis for Oracle performance tuning.  Finding the mathematical functions that describe the computational complexity of different operations can help us understand and predict performance.  This presentation will discuss common functions such as 1/N, LOG(N), N, N*LOG(N), N^2, and N!, and how they can help us understand operations such as…

Historical trends of the last decade lead to a paradox: In search of optimization, our solutions represent a group of independent modules communicating via various APIs (up to an extreme point of micro-services!) The overall number of performance problems increased significantly (comparing to the past, i.e. monolithic implementations). In addition, time to solve any performance…

One of the most common SQL Tuning problems is when the Oracle cost-based optimizer misestimates the expected number of rows that will be returned from an execution plan row source operation. This presentation delves into uncharted waters to help attendees understand strategies for dealing with cardinality misestimates.

The methods used to track performance issues in SQL and PL/SQL vary based on the level of access within a system.  A developer in cooperation with a DBA, or already granted DBA privileges can has a wide variety of tools and deep visibility.  However, a user with nothing more than CREATE SESSION and SELECT privileges…

  Use the innovative Dynamic Oracle Performance Analytics (DOPA) approach that relies on big data and advanced analytical techniques to analyze and improve Oracle Database performance. The approach discussed in this presentation is accessible and easy to use, but more importantly it represents a step-change paradigm shift away from traditional methods. Instead of relying on…