Oracle Cloud Infrastructure Documentation

Use the AWR Explorer

AWR Explorer in Ops Insights lets you compare database performance data stored in AWR Hub without having to toggle between hourly AWR reports.

From a single interface that integrates performance and data visualization tools, you can view historical performance data from AWR snapshots in easy-to-interpret charts, thus allowing you to quickly analyze performance trends and detect issues.

Using AWR Explorer in Ops Insights lets you:

  • View and analyze AWR data across different database systems
  • Easily identify performance trends without needing to toggle between hourly AWR reports
  • Visualize different aspects of Oracle Database performance data which can be helpful in detecting performance issues

Accessing AWR Explorer

To access AWR Explorer:

  1. Open the navigation menu, click Observability & Management, and then click Ops Insights.
  2. In the left pane, click Database Insights, and then click AWR Hub.
    Note

    All databases providing AWR snapshots are listed. If you have not yet set up AWR Hub or configured source databases to send AWR snapshots to AWR Hub, see Configure the AWR Hub.
  3. To open AWR Explorer, click the Actions menu for a database, and then select Launch AWR Explorer.

    The following fields are displayed in AWR Explorer. You can select the options in these fields to determine the data to be displayed:

    • Database: The name used when registering the database with AWR Hub.
    • Time range: Duration of the snapshot range for which AWR data is displayed. By default, the duration of the latest AWR snapshot range is selected. However, if the snapshot range has more than six snapshots, then the default time range is the duration of the most recent six snapshots in the snapshot range. For example, if the duration of each snapshot (snapshot interval) is 10 minutes, then the time range is 6 * 10 minutes = 1 hour and the data within this time range is displayed.

      Click the Time range field to view the Custom time range dialog and change the duration within the selected time range, if required.

    • Time zone: Time zone in which AWR data is displayed. By default, the UTC (Coordinated Universal Time) time zone is selected. Click this field to replace the default time zone with your local browser time zone.

AWR Explorer Tabs

AWR Explorer displays the following tabs, which provide information on the important aspects of database performance within the selected time range. These tabs display charts that greatly simplify the interpretation and comparison of AWR data.

  • Load profile: This tab displays historical system statistics from AWR tables such as DBA_HIST_SYSSTAT. The charts display the default SYSSTAT categories, such as Time model overview, Connections, and Logons, which provide an overview of the global health of the database.

    On the Load profile tab, you can add charts to display other supported system statistics. To do so:

    1. Ensure that Custom is selected in the System statistics drop-down list.
    2. Click Add load profile chart.
    3. In the Add custom load profile chart panel, enter a title for the new chart, select the system statistics that you want to display, and click Add load profile chart.
  • Wait events: This tab displays the top ten wait events sorted by wait time from AWR tables such as DBA_HIST_SYSTEM_EVENT. The charts display the wait event and the corresponding Waits per second and Average wait time information.

    On the Wait events tab, you can also:

    1. Add new charts to display more wait events. To do so, select a wait event in the Wait event drop-down list and click Add wait event chart.
    2. View a histogram of the wait event with a breakdown of the percentage of waits by their duration, within a selected snapshot range. To do so, click the Show histogram option available for each wait event chart.
  • Activity: This tab enables you to view database performance trends by selecting an ASH dimension for the Average active sessions chart and viewing the top activity for that dimension in the selected time range. You can also scroll down to view the top activity by additional dimensions based on the dimension selected in the Average active sessions chart. For example, if the default dimension, Wait class is selected in the Average active sessions chart, then you can view the top SQL ID and Wait event by Wait class or select other dimensions in the menus on the top left of the tables.
  • Database parameters: This tab displays all the database parameters that were changed and you can click the link in the Changed column to view the change details for a parameter. The change history information includes details such as the ID of the snapshot when the database parameter was changed, the start and end time of the snapshot, and the changed value.

    On this tab, you can also view all the database parameters, including those that were not changed. To do so, deselect the Hide Unchanged Parameters check box.

AWR Chart Visualization Options

AWR Explorer provides the following data visualization options to enable you to filter data and make changes to how data is displayed in the charts.

  • Display raw data or chart (Display raw data/chart): Click to switch between a line chart and raw data. You can use this option to copy and analyze raw data.
  • Change to bar or line chart (Change to bar/line chart): Click to switch between a line chart and a bar chart. Note that a change made to the visualization option in one chart applies to all the charts on the tab.
  • Zoom in and Zoom out (Zoom in and Zoom out): Click to alter the scope of what is displayed in the chart. After clicking the Zoom in icon, you can use mouse and touch pad to scroll to the right or left of the chart, and zoom in and out. Note that a change made using the zoom options in one chart applies to all the charts on the tab.
  • Restore (Restore): Click to undo any changes made to the charts using the other options and return to the default display.
  • Save chart as image (Save chart as image): Click to save the chart in .png format.
  • Remove chart (Remove chart): Click to remove the chart from the tab. You can add the chart again by selecting it in the drop-down list on the tab and clicking Add <name of tab> chart.

Generate Reports

You can generate and download various reports from the database in AWR Explorer.

To do so, click Reports and select one of the following options:

  • AWR: In the Generate AWR report panel, select the snapshot range and click Generate report to generate and download an AWR report with additional performance data.
  • SQL: In the Generate SQL health check report panel, select the snapshot range, specify a SQL ID, and click Generate report to generate and download a SQL Health Check report with additional performance data for the specified SQL statement.
  • ASH: In the Generate ASH report panel, select the start and end time and click Generate report to generate and download an ASH report with additional ASH data.