Oracle 9i Performance & Tuning Guide

Advanced Tuning with Statspack (Part 2) - Previously, we examined how you can use Statspack reports to monitor and resolve wait events. Now, let's examine issues regarding tuning latch waits. In this article I'll discuss some undocumented initialization parameters (those preceded with an underscore). I recommend checking with Oracle Support before changing these parameters.

Performance Tuning With Statspack, Part II

Advanced Tuning with Statspack (Part 1) - If you could choose just two Oracle utilities to find and monitor performance problems in your Oracle9i Database system, those two utilities would be Oracle Enterprise Manager (now available in Release 4.0) and Statspack. As of Oracle8i Release 8.1.6, the Statspack utility replaced the UTLBSTAT/UTLESTAT scripts available for performance monitoring with earlier versions of Oracle Database; Statspack offers several significant enhancements to those scripts. This column focuses on solutions to advanced issues regarding wait events - those events for which your system had to wait during processing for a resource to become available, an action to complete, and so on.

When to Use an Index - A simple rule of thumb may hinder your performance.

Why You Should Focus On LIOs Instead Of PIOs - Additions to the 99%+ paper that explain why Logical IOs aren't always faster than Physical IOs.

Why a 99%+ Database Buffer Cache Hit Ratio is Not OK - A document warning against the dangers of relying on cache hit ratios.

Yet Another Performance Profiling Method (YAPP Method) - Oracle tuning without reference to Hit-Ratios.

Oracle Performance Mangement - A Radical Approach - Overview of YAPP method.

Performance and Tuning FAQ

Performance and Tuning Scripts

BACK TO ARTICLES MAIN PAGE