Oracle Statspack and Oracle Automatic Workload Repository (AWR) in RSA Identity Governance & Lifecycle
Originally Published: 2020-03-10
Article Number
Applies To
RSA Version/Condition: 7.0.x, 7.1.x, 7.2.x
Issue
Is Oracle Statspack needed if you have an AWR license?
Resolution
Usage of Statspack depends on the performance statistics that you want to collect. Statspack can be configured to report the same data as an AWR, however, analyzing the reports is easier with an AWR. With Statspack, you have to do the work yourself.
The AWR reports on more up-to-date information than Statspack and in more detail. The AWR works in conjunction with the Automatic Database Diagnostic Monitor (ADDM) to do the performance analysis for you, and can self-manage the data capture/purge. In addition, the AWR can be viewed and managed using the Oracle Enterprise Manager (OEM) user interface.
Additional information collected by Statspack and not the AWR:
- Event Histogram
- File Histogram
- Streams related data capture
- Active Session History (ASH)
- Service Statistics
- Metric Statistics
- Tablespace usage
To install Oracle Statspack, See the RSA Identity Governance & Lifecycle Database Setup and Management Guide, Chapter 2 Set Up the Database for information about Installing Oracle Statspack.
Generating an AWR report requires licensing to use the Oracle Diagnostics Pack. Customers using a customer-supplied database with RSA Identity Governance & Lifecycle should refer to their DBA team to verify the ability to generate AWR. Customers using an RSA-provided database with RSA Identity Governance & Lifecycle must generate a database performance statistics report, an alternative to AWR, for troubleshooting database performance issues. For more information, see: How to generate Oracle database performance statistics in RSA Identity Governance & LifecycleRelated Articles
RSA Announces the Availability of RSA Identity Management and Governance 6.9.1 Patch 25 Number of Views DSA-2020-112: RSA Authentication Manager Security Update for Third Party Component Vulnerabilities Number of Views Access Manager Agent will not start - 403 error Number of Views Determining Access Requirements for High-Risk Users in Cloud Access Service Number of Views Obtain the Identity Router Image Number of Views
Trending Articles
RSA MFA Agent 2.3.6 for Microsoft Windows Installation and Administration Guide RSA Authentication Manager 8.9 Release Notes (January 2026) How to install the jTDS JDBC driver on WildFly for use with Data Collections in RSA Identity Governance & Lifecycle RSA Authentication Manager 8.8 Setup and Configuration Guide Artifacts to gather in RSA Identity Governance & Lifecycle
Don't see what you're looking for?
