1. Using Oracle® SQL Developer Web
  2. The Activity Pages
  3. The Performance Hub Page

4.3 The Performance Hub Page

Availability icon Available only if you signed in to a dedicated Oracle Autonomous Transaction Processing database as a user with administrator rights.

The Performance Hub page shows performance data for a time period you specify. It consists of these parts:

  • Time Range Area. Use the controls in time range area at the top of the page to specify the time period for which you want to view performance data.

  • ASH Analytics Tab. Use this tab to explore ASH (Active Session History) information across a variety of different dimensions for the specified time period.

  • SQL Monitoring Tab. Use this tab to view the top 100 SQL statement executions by different dimensions for the specified time period, and to view details of SQL statement executions you select.

Time Range Area

Use these controls in the time range area to specify the time period for which you want to view performance data:

  • Timeframe Dropdown. Use this dropdown list, located in the top right of the time range area, to set the timeframe displayed in the timeline. You can choose Last hour, Last 8 hours, Last 24 hours, Last Week, or you can choose Custom and define your own timeframe.

  • Timeline. The timeline displays a graph spanning the timeframe selected in the timeframe dropdown, showing Waits, User I/O and CPU usage during the period. At its end is the time slider.

  • Time Slider. The time slider is a box you can drag back and forth along the current timeline. Use it to pick the specific time period within the timeframe for which you want to view performance data. You can also drag the side handles on the time slider to make it wider or narrower to encompass a longer or shorter time period.

ASH Analytics Tab

The ASH Analytics tab consists of the Average Active Sessions chart and two secondary tables below it.

  • Average Active Sessions Chart. This chart shows performance information for the time period defined by the time slider. You can choose to chart different dimensions of information, such as Wait Class, Wait Event, or Service, by selecting the dimension from the dropdown list to the right of the chart title.

    You can download an AWR (Automatic Workload Repository) report for the current time period by right-clicking in the Average Active Sessions chart area and choosing Generate AWR Report.

    For more information about ASH and AWR, see Active Session History (ASH) and Automatic Workload Repository (AWR) in Oracle Database Concepts.

  • Secondary Tables. The two tables below the Average Active Sessions chart show the information dimension chosen in the chart filtered by another dimension you choose. For example, if the Average Active Sessions chart is showing Wait Class, you could show SQL ID and User Session dimension information by Wait Class, one in each of the two secondary tables.

    In the secondary tables, the SQL ID and User Session dimensions provide links to SQL Details and Session Details pages, respectively, for the dimension data listed in the table.

SQL Monitoring Tab

The SQL Monitoring tab shows a table of the top 100 monitored SQL statements that were executing or that completed during the selected time period.

The table displays information about monitored SQL statement executions. If there is a green spinning icon in the Status column, then the monitored statement did not complete during the selected time period. A red cross indicates that the SQL did not complete either due to an error or due to the session getting terminated. If there is a check mark in the Status column, then the statement completed its execution during the selected time period.

SQL statements are monitored only if they have consumed at least 5 seconds of CPU or I/O time.

You can view information such as the status of a statement, its duration, its type (SQL, PL/SQL, or DBOP), its SQL ID, its SQL plan hash, the user who issued it, whether it executed as a serial or parallel statement, the time the database spent performing CPU activity, I/O, or other activity for the statement, the read and write requests and bytes associated with the statement, and the start and end time for the statement.

Click a SQL ID to display the SQL Details page with more information about that SQL statement.