Gantt Chart

To view the Gantt Chart:

1. Open the Performance Hub page from the database details page, if not already open.

   Note:

   For more information about how to navigate to the Performance Hub page, see:

   • For Autonomous AI Database

   • For Base Database Service and Exadata Databases

   • For External Database Service

2. Click SQL Monitoring to display the SQL Monitoring tab.

3. On the right side of the SQL Monitoring report, click the Gantt Chart View option. This option displays the SQL monitoring details in the Gantt chart.

   Note: The Gantt chart view is only supported for time slider ranges up to 1 hour.

Using the Gantt Chart

You can view the following details using the Gantt chart:

• The Top 100 SQL executions are displayed in the chart. By default, the top 100 SQL executions by last active time are displayed. You can also sort using duration, database time, CPU time, I/O requests, and I/O bytes in addition to last active time.

• The Show SQL IDs switch can be toggled to display or hide IDs for SQL executions.

• The SQL Duration filter can be used to filter SQL executions by duration. You can specify the duration for filtering for minimum, maximum, or both.

• Additionally, you can use the Filter menu to filter based on various criteria such as status, parallel execution, type, operation, and cross-sharding.

• The chart can be zoomed in or out using the mouse or the + and - icons in the top right corner.

• Hover over the statements in the chart to get details about the SQL statement such as plan hash, session serial number, module, action, service program, DB time, start time, end time, duration, and errors, if any.

• Click a SQL execution bubble in the chart to view the real-time SQL monitoring page for that SQL execution. Right-click a bubble to view a context menu of additional options where you can do the following:

  • Select executions with the same SQL ID.

  • Copy SQL ID to the clipboard.

  • Terminate the session if SQL execution is running.