Oracle Cloud Infrastructure Documentation

Using Performance Hub to Analyze Database Performance in Oracle Cloud Infrastructure

Note

Performance Hub is currently available for Autonomous Databases using the serverless deployment option.

This topic describes how to use Oracle Cloud Infrastructure's Performance Hub tool for Oracle Database performance analysis and tuning. Performance Hub offers two performance monitoring tools in the Console, Active Session History (ASH) Analytics and SQL Monitoring.

You can view real-time and historical performance data in Performance Hub. When you view historical data in the Performance Hub, you are viewing statistics collected as part of the hourly snapshots of your database.

The Performance Hub page consists of the following sections:

  • Time Range field and time slider:

    The Time Range selector is displayed on the top of the Performance Hub page. Use the Select Duration field to set the time duration. By default, Last 60 mins is selected. You can choose to view Last 8 hours, Last 24 hours, Last week, or specify a custom time range using the Custom option.

    The Time Range field shows active sessions in chart form for the time period selected. The active sessions chart displays the average number of active sessions broken down by CPU, User I/O, and Wait.

    The sliding box on the time range chart is known as the time slider. Use the time slider to select the exact period of time for which data is displayed in the Performance Hub tables and graphs. This is a subsection of the period of time shown in the Time Range field. In the image that follows, red and blue arrows point to the vertical 'handlebar' elements on the left and right boundaries of the slider box.

    This image shows the Time Range portion of the Performance Hub screen is shown. Arrows identify the left and right boundaries of the time slider box.

    You can slide the box to the left or the right to shift the time period under analysis. To slide the entire box, left-click anywhere inside the box and drag the box to the left or the right.You can widen or narrow the box to increase or decrease the length of time under analysis. To widen or narrow the box, left-click and hold the handlebar on either side of the box, then drag to the left or the right to increase or decrease the size of the box.

    To refresh the data in Performance Hub according to the time range chosen, click the Refresh button.

  • Active Session History (ASH) Analytics tab:

    Displayed by default. The ASH Analytics tab shows Active Session History (ASH) analytics charts to explore ASH data. It allows you to drill down into database performance across multiple dimensions such as Consumer Group, Wait Class, SQL ID, and User Name. On the ASH Analytics tab, you can select an Average Active Sessions dimension and view the top activity for that dimension for the selected time period. For information on ASH, see Active Session History (ASH) in Oracle Database Concepts.

  • SQL Monitoring tab:

    The SQL Monitoring tab is not displayed by default. To view it, click SQL Monitoring on the Performance Hub page.

    SQL statements are only monitored if they've been running for at least five seconds or if they're run in parallel. The table in this section displays monitored SQL statement executions by dimensions including Last Active Time, CPU Time, and Database Time. The table displays currently running SQL statements and SQL statements that completed, failed, or were terminated. The columns in the table provide information for monitored SQL statements including Status, Duration, and SQL ID.

    The Status column has the following icons:

    • A spinning icon indicates that the SQL statement is executing.
    • A green check mark icon indicates that the SQL statement completed its execution during the specified time period.
    • A red cross icon indicates that the SQL statement did not complete, either due to an error, or due to the session being terminated.
    • A clock icon indicates that the SQL statement is queued.

    To terminate a running or queued SQL statement, click Kill Session.

    You can also click an SQL ID to go to the corresponding Real-time SQL Monitoring page. This page provides additional details to help you tune the selected SQL statement.

Using the Oracle Cloud Infrastructure Console

To view the average active session data by a selected dimension
To filter average active sessions data
To view the SQL Monitoring report