|Applies To||RSA Product Set: RSA Identity Governance & Lifecycle|
RSA Version/Condition: 7.x
|Issue||What 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?
|Resolution||Oracle 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:
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.