Spotlight on Oracle 10.10 - Release Notes

First Time Users

Although you can use any feature in Predictive Diagnostics at any time, we recommend the following procedure for first-time users.

1. Follow the suggestions in What To Do Next.

   The quality of predictions depends on the quality of the data on which they are based. What To Do Next tracks the current status of the data and indicates when that data is incomplete or outdated.

2. Wait until enough real data is available.

   This usually occurs about 10 days after you begin monitoring the database. Before that time, become familiar with how Predictive Diagnostics works by using the supplied Sample Data.

3. Improve how the database is used now by using SQL Performance and Impending Bottlenecks - Timed Statistics to optimize data processing on the host system.

   Note: The changes you make as a result of using these features MAY cause the data you collected earlier to become outdated. If so, you may need to set Trend Changes and collect new data for another 10 days.

4. Establish the resources available to the database.

   Use Configuration to set realistic parameters for the CPU, memory and disk I/O resources available to the database. (The default settings we provide for these parameters may not be appropriate for your database.)

   In particular, use Peak Processing Periods to identify WHEN database resources are in greatest demand. This will improve the precision of your predictions.

5. Use Performance Modeling to predict when and why database resources will run out, what will cause performance to suffer, and what you need to do to counter those