Tag: Database Performance Tuning
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…
- Quest Customer Learning Team
- Webinars
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…
- Quest Customer Learning Team
- Whitepapers & presentations
- 4/11/19
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…
- Quest Customer Learning Team
- Whitepapers & presentations
- 4/08/19
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…
- Quest Customer Learning Team
- Whitepapers & presentations
- 4/01/19
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…
- Quest Customer Learning Team
- Whitepapers & presentations
- 4/01/19
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.
- Quest Customer Learning Team
- Whitepapers & presentations
- 3/21/19
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.
- Quest Customer Learning Team
- Whitepapers & presentations
- 3/21/19
