1. Using Oracle Database Actions for On-Premises Oracle Database
  2. The Monitoring Pages
  3. The Top SQL Page

8.10 The Top SQL Page

Note:

Available only if you signed in as a database user with DBA and PDB_DBA roles.
The Top SQL page displays SQL statements executed in the database based on CPU time consumed. The SQL statement that consumes the maximum CPU time is right at the top, and the remaining statements continue in descending order of CPU time.

To navigate to the Top SQL page, do either of the following:

  • In the Launchpad page, click Top SQL.

  • Click Selectorselector iconto display the navigation menu. Under Monitoring, select Top SQL.

This feature enables you to focus your SQL tuning efforts on the statements that can have the most impact on database performance.

Click a row to see a formatted view of the SQL statement, the execution plan, the runtime history from Active Session History, and a SQL Tuning Advisor report. Active Session History is part of the Diagnostics Pack, and SQL Tuning Advisor is part of the Tuning Pack for Oracle Database.