TruTek

The purpose of this paper is to describe:

- Understanding what STATSPACK is, what it can, and cannot do

- How to install it properly

- How to use it to optimize performance in the database

- What its shortcomings are

STATSPACK is intended for tuning the performance of an Oracle database, regardless of what other tuning tools are in use or what application is using the database. It is a repository for the dynamic performance information generated by many of Oracle's internal V$ views. This repository is merely an extension of the V$ views, most of which are based completely in memory and thus cannot retain data across a restart of the Oracle database instance. Moreover, the STATSPACK repository consists of point-in-time snapshots of the data in the V$ views, so the amount of change between snapshots is retained, not just the current cumulative value. This allows a database administrator (DBA) to pinpoint time periods in which changes occurred and the rate of change.

When asked to "Select a payment method" for your free download, choose "Print and Call". Your download code will be e-mailed to you after we authorize it. International customers should enter TruTek's address as the shipping address and enter their real shipping address in the Special Instructions field on the payment screen.