Configuring Change Tracking

Performance Analysis for Oracle

Performance Repository

Identification

The Repository Manager is responsible for populating the long-term Performance Repository and change tracking. Use the status indicators to verify that the data collections and change tracking are active.

Attribute

Description

Host

The monitored host on which the repository is installed.

Instance

The specified instance on the monitored host.

Port

The TCP/IP port through which the repository instance is monitored.

Version

The StealthCollect Repository Manager version.

Oracle Repository account

Username: The user under which the repository was accessed.

Change Tracking

The change tracking tool is an integrated monitoring feature available only if the repository is installed. It periodically tracks changes in environments and activity that can potentially influence system performance and enables the user to view correlation between occurrences of changes and Oracle's activity and behavior patterns.

The change tracking process is performed within the StealthCollect Repository manager.

To enable/disable Change Tracking

  • Select/clear the Enable change tracking checkbox to enable/disable change tracking.

To set the retention period for change tracking data

  • Set the period for which discovered change occurrences are stored in the Performance Repository by specifying the expiration period in the Expire changes after box (measured in days). Change items dated beyond the threshold are automatically aged out.

To configure the tracked change types

The inclusiveness of the tracked change types determines the monitored Oracle instance overhead and repository space requirements. Therefore, track only those change types which are relevant to your system.  

  • Select/clear the change types from their associated checkboxes for the inclusion/exclusion of the change type.

To schedule the Change Tracking

Change tracking is a periodic process executed at specified intervals.

  1. Specify which days of the week, which exact time (hh:mm:ss) within these days the change tracking process is to be executed. By default, the process is executed daily at midnight.

  2. Enable multiple daily change tracking in the times per day box.

Maintenance

The Performance Repository is designed to hold a large volume of data. The Performance Repository has a built-in feature for analyzing its objects and rebuilding its indexes to ensure its robustness and performance quality. The maintenance procedures automatically are executed in the background in accordance with your configuration.

To customize Repository maintenance procedure

  1. Select/clear the Analyze tables checkbox for inclusion/exclusion of this repository maintenance procedure.

  2. Select/clear the Index rebuild checkbox for inclusion/exclusion of this repository maintenance procedure.

  3. Set the performance statistics and Change Analysis loading time (in seconds) thresholds which when exceeded trigger performance of the repository maintenance procedures.

  4. Specify the minimal interval (in hours) between each execution of maintenance procedures.

  5. Click Perform Now.

Instance List

The instances (and their hosts) served by the specified performance repository are listed here, in addition to the repository space allocation totals.