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


Conquering Oracle Latch Contention (March 2005) IOUG 2005, RMOUG '06, IOUG/Collab 2007 Tech Paper Free
Getting Started Optimizing Oracle Performance PRESENTATION (21-March-2008, IOUG/Collab '08) Free
Oracle DB Server Stress Identifier (v2a) $49.95
Simple Linear Regression Analysis Template (2n 09-July-07) Free
Index Organized Tables -- When should they be used? (April-2002) Free
Getting Started Forecasting Oracle Performance PRESENTATION (21-March-2008, IOUG/Collab '08) Free
All About Oracle's In-Memory Undo (v1n, 22-January-2009) Technical Paper Free
OraPub System Monitor (OSM) Toolkit (v12y for Ora 7-11g, 08-Feb-2010) Free
Total Performance Management (Feb 1995) Free