Compulsive Tuning Disorder
At the ripe age of 33, I had the pleasure of co-authoring my first book, Oracle Performance Tuning 101. It was published by Oracle Press in the wonderful month of June, during the year of the lord 2001. My first book was originally intended to be only 42 pages long, and that should have sufficed. After all, the answer to every question in the Universe is 42, so why couldn’t the details about Oracle performance diagnostics be shared within 42 pages? For those of you who have absolutely no clue what I am talking about, I urge you to seek out sources of literary material other than your Oracle documentation. The essence of 42 can be retrieved from Douglas Adams’s classic book, The Ultimate Hitchhiker’s Guide to the Galaxy.
KeywordsTrace File Tuning Effort Oracle Database Performance Optimization Effort Oracle Performance
Unable to display preview. Download preview PDF.
- 1.Holt, Jeff, and Cary Millsap. “Oracle System Performance Analysis Using Oracle Event 10046.” Hotsos (http://www.hotsos.com), 2002.Google Scholar
- 2.Van der Kolk, Bessel A. “The Compulsion to Repeat the Trauma.” Psychiatric Clinics of North America 12, no. 2 (1989): 389-411.Google Scholar
- 3.Millsap, Cary. “Why a 99%+ Cache-hit Ratio is NOT Ok?” Proceedings of the International Oracle Users GroupAmericas, 2001.Google Scholar
- 4.Millsap, Cary, and Jeff Holt. Optimizing Oracle Performance. Sebastopol, CA: O’Reilly & Associates, 2003.Google Scholar
- 5.Shallahamer, Craig. “Direct Contention Identification Using Oracle’s Session Wait Virtual Tables.” OraPub white paper, 2001.Google Scholar
- 6.Vaidyanatha, Gaja Krishna, Kirtikumar Deshpande, and John A. Kostelac. Oracle Performance Tuning 101. Emeryville, CA: Osborne McGraw-Hill, 2001.Google Scholar
- 7.Vaidyanatha, Gaja Krishna. “Oracle Performance Management.” Proceedings of Oracle OpenWorld 2000.Google Scholar
- 8.Zabenskie, Audrey. Life Behind Bars: Living with Obsessive Compulsive Disorder. Winnipeg: 2002.Google Scholar