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 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 will display 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 minimum and/or maximum duration values for filtering.
• 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 on a SQL execution bubble in the chart to view the real-time SQL monitoring page for that SQL execution. Right-click on a bubble to view a context menu of additional options that allow you to select executions with the same SQL ID, copy the SQL ID to the clipboard, or terminate the session (if the SQL execution is currently running).