Advertisement

You Probably Don’t Tune Right

… and perhaps you never will
  • Mogens Nørgaard

Abstract

To me, the Oracle performance optimization research carried out by the likes of Anjo Kolk, Cary Millsap, and several others, over the last 15-20 years can be summed up in two sentences:
  • If you don’t know where the time is going on the session/job level, you cannot optimize. You’re reduced to guesswork. See Anjo Kolk’s “YAPP-Method” paper (Anjo tells the story behind YAPP in Chapter 4 of this book) and Cary Millsap’s “Oracle Operational Timing” paper, among others, for details. Also, of course, you should read Cary’s chapter in this book and buy Optimizing Oracle Performance (O’Reilly & Associates, ISBN 059600527X).

  • Control your batch load, and realize that many online jobs/sessions behave (and should be treated) as batch jobs. See Cary Millsap’s “Batch Queue Management and the Magic of ‘2’” paper.

Keywords

Execution Plan Oracle Database Buffer Cache Workload Reduction Premium Service 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

Copyright information

© Mogens Nørgaard, James Morle, Dave Ensor, Tim Gorman, Kyle Hailey, Anjo Kolk, Jonathan Lewis, Connor McDonald, Cary Millsap, David Ruthven, Gaja Krishna Vaidyanatha 2004

Authors and Affiliations

  • Mogens Nørgaard

There are no affiliations available

Personalised recommendations