AWR Analyzer is distributed as a plug-in for the Oracle® SQL Developer tool.
It provides users with a quick SQL analysis and problems detection in attractive GUI without requiring an installation of any database procedures, triggers or functions. It is fully operational right after the installation.
The plug-in also contains the basic SPM (SQL PLAN MANAGEMENT) functionality.
Analytic tool AWR Analyzer is developed for Oracle® databases of version 11.2 or higher and both Standard and Enterprise editions (AWR or STATSPACK).
The standard STATSPACK/AWR analyzer provided by Oracle corporation as a component of the Oracle database has to be executed as a script and only provides the output in the text form, which is complicated to read. Also, it is not possible to see SQL execution plan without creating new output. Text output is divided to several sections and to find the links between data user has to scroll between particular sections.
The plug-in is originally delivered in two language mutations:
• English
• Spanish
Why use AWR Analyzer
Analyze AWR plug-in represents data in much more user-friendly GUI:
• Tabular data output
• Filter data by SQL Module
• Details of the SQL query accessible on one click, with possibility to open details in the new tab on double-click.
• Display of SQL statement in formatted form
• SQL execution plan
• Exporting of the selected data into PDF or Excel file or into clipboard
• Possibility to define quantity of displayed data
In addition, it provides the data and the tools which are not components of the original AWR:
• #Of Exec. Plans – number of the distinct execution plans used for the particular SQL statement
• Binding Variables – logical true/false value which represents whether given SQL has stored binding variables during the run
• SQL Plan Management – tool for maintaining the execution plans (detailed description of SPM functionality is available on the official Oracle web-page)
INSTALLATION REQUIREMENTS
Minimum requirements for the installation of AWR Analyzer:
• Operating system: macOS®, Windows® a Linux®
• SQL Developer: version 19.2.* or higher
Note: Plug-in doesn’t provide an Oracle license for using AWR (Automatic Workload Repository).
To use AWR functionality, it is necessary to own the Oracle Diagnostic Pack license.
You can find license fees in official Oracle price list or your Oracle distributor.
AWR Analyzer works with both Oracle RAC and non-RAC systems from the version 11.2.
For the correct functionality of the plug-in, it is necessary to have installed a STATSPACK or AWR package and grant User Rights for the objects.
*it is possible to provide plug-in for older versions after the consultation. Minimum number of licenses is 20.