About Oracle Performance Analyzer

Oracle Performance Analyzer examines the use of an Oracle database over a specified period of time and provides recommendations to improve the performance of the database applications used. In some cases, the recommendations can be automatically implemented by clicking a button.

Oracle Performance Analyzer is implemented using AWR snapshots and ADDM tasks For more information on AWR and ADDM, see Oracle Database Performance Tuning Guide.

This section covers the following topics:

• Privileges

• Licensing

Privileges

You must have the SYSDBA role to use Oracle Performance Analyzer.

Licensing

Oracle Performance Analyzer requires the Oracle Diagnostic Pack license and SQL Tuning Advisor requires Oracle Tuning Pack License. Dialog boxes appear to notify you of licensing requirements.