Spotlight on Oracle 10.9 - Getting Started Guide

Installation / Data

Installation

Use the Oracle User Wizard to create a new Spotlight user (or modify an existing user) that employs Predictive Diagnostics. Spotlight will:

• Install a Predictive Diagnostics schema on the Oracle database (or use an existing schema if available).
• Run data collection jobs for Predictive Diagnostics at regular intervals (by default, every 12 hours for SQL performance and every 10 minutes for bottlenecks).

• Predictive Diagnostics runs three lightweight Oracle jobs on the database under investigation (one for each diagnostic category) in order to collect the data used in its analysis.

Notes:

• If Predictive Diagnostics is unavailable for your Spotlight connection then re-run the Oracle User Wizard to install Predictive Diagnostics.
• Ensure you set the correct Oracle Parameters for Predictive Diagnostics to collect the data it needs.
• See also Data Storage Requirements for Predictive Diagnostics.

Sample data

When you start using Predictive Diagnostics, Spotlight will take about 10 days to collect enough data to make valid predictions on the future performance of your database. During that time, you can use the supplied sample data to view Predictive Diagnostics at work. Sample Data