You Probably Don’t Tune Right
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.
KeywordsExecution Plan Oracle Database Buffer Cache Workload Reduction Premium Service
Unable to display preview. Download preview PDF.