Home > Technical Papers/Books >

  Modern Performance Myths - Presentation RMOUG/IOUG/Collab'06/OOW'06 (October 2006)
 
 
Our Price: Free


Availability: Available for download now
Product Code: MYTHS_PPT

Description
 
Oracle performance analysis has come a long way in the last 20 years.  First there was the “just add more resources” approach and tuning the blatantly poor SQL.  Then there was ratio analysis followed by wait event analysis.  Finally, response time analysis (RTA), in a way, closed the loop.  What is so key about RTA is that it brought together and detailed the two elements of response time, that is, service time and queue time.  But over the past couple of years, while DBAs talk about Oracle timing and response time analysis, for the most part, the focus rests solely on the wait interface.  And this unhealthy focus on the wait interface is where the modern performance myths lie in wait…

The four myths are:

Myth #1. Decreasing wait event time will always decrease Oracle response time.
Myth #2. Decreasing wait event time will always decrease end-to-end response time.
Myth #3. Profiling sessions is the best way to diagnose performance problems.
Myth #4. Focusing on where most of the time is spent is always the best approach.
 


Browse for more products in the same category as this item:

Technical Papers/Books


Me? Forecast Performance? Free
A Study in PCTFree In B*-Tree Indexes (Dec-2002) Free
RT Comparison/Case Graphs (1g, 16-May-2010) Free
RT Interactive Graphs (1b,01-Sep-2009) Free
OraPub System Monitor (OSM) Toolkit (v12y for Ora 7-11g, 08-Feb-2010) Free
OraPub Load Generator (1c 05-June-2008) Free
Getting Started Optimizing Oracle Performance (v1d, 12-Feb-2008, IOUG/Collab '08) Free
Predicting The Performance Of 3 Tier Systems. (11-Mar-2002) Free