Use the Oracle User Wizard to create a new Spotlight user (or modify an existing user) that employs Predictive Diagnostics. Spotlight will:
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.
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