000038552 - Oracle Statspack and Oracle Automatic Workload Repository (AWR) in RSA Identity Governance & Lifecycle

Document created by RSA Customer Support Employee on Mar 10, 2020
Version 1Show Document
  • View in full screen mode

Article Content

Article Number000038552
Applies ToRSA Product Set: RSA Identity Governance & Lifecycle
RSA Version/Condition: 7.x
IssueWhat are the differences between Oracle Statspack and Oracle Automatic Workload Repository (AWR) in RSA Identity Governance & Lifecycle? 
Is Oracle Statspack needed if you have an AWR license?
ResolutionOracle Statspack collects performance statistics and the Oracle AWR does performance analysis.

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 Statsback and not the AWR:
  • Event Histogram
  • File Histogram
  • Streams related data capture
Additional information collected by the AWR and not by Statspack:

  • 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 on Installing Oracle Statspack.

AWR comes with the Oracle database software distributed by RSA. If you have a customer-supplied database, contact your Oracle DBA.
For more info on AWR see 000037779 How to generate an Oracle Automatic Workload Repository (AWR) report for RSA Identity Governance & Lifecycle.