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.
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.
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
Select/clear the Analyze tables checkbox for inclusion/exclusion of this repository maintenance procedure.
Select/clear the Index rebuild checkbox for inclusion/exclusion of this repository maintenance procedure.
Set the performance statistics and Change Analysis loading time (in seconds) thresholds which when exceeded trigger performance of the repository maintenance procedures.
Specify the minimal interval (in hours) between each execution of maintenance procedures.
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.