Tuning Statistics

Tuning statistics are measurements that reveal useful information about system functions. You analyze tuning statistics to help you determine the issues that can benefit most from tuning. This section introduces several key concepts related to tuning statistics, including brief descriptions of several commonly referenced tuning statistics, instance efficiency ratios, the V$ data dictionary views, and Statspack.

Commonly Referenced Tuning Statistics

Oracle XE automatically collects information pertaining to many, many statistics. While each and every statistic has a purpose, some statistics are more frequently used than others. Table 10-1 identifies some of the more commonly used statistics that you will pay attention to in subsequent ...

Get Hands-On Oracle Database 10g Express Edition for Windows now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.