Spotlight on Oracle 11.0 - Getting Started Guide

Impending Bottlenecks Oracle Job

Specify the nature of the raw data collected by Predictive Diagnostics.

To set Impending Bottlenecks Oracle Job

1. Click View | Options
2. Click Predictive Diagnostics | Impending Bottlenecks Oracle Job

3. Configure the following options:

   Setting	Description
   Data Collection Interval	How often to collect Predictive Diagnostics data. Note: If you enter the value 0 (zero), Spotlight will never collect data.
   Data Retention Period	The period of time that collected data is kept by Predictive Diagnostics. Valid values range from 30 days to 731 days (two years). Note: If you enter the value 0, Spotlight will never purge the collected data. This is NOT recommended, however, as it will adversely affect the performance and space usage of Predictive Diagnostics.
   Data Analysis Options	The Do not analyze data before... option sets a start date for the analysis.

Note: On a shared Predictive Diagnostics connection…

• To change Job Options the connected Spotlight user needs to be the owner of the Predictive Diagnostics database objects and the first Spotlight user connected in the session. If you see a message indicating you cannot change job options then ensure all connections currently using these database objects are closed and connect as the Spotlight user that owns the database objects.
• Changes made to these options are available to other Spotlight users that use the database objects.

Related Topics

Predictive Diagnostics - View | Options

Predictive Diagnostics

Impending Bottlenecks - Timed Statistics