4.9 The Top SQL Page

Available only if you signed in as a database user with the DBA role.

The Top SQL page displays SQL statements based on CPU time consumed, that are executed in the database. The SQL statement that consumes the maximum CPU time is right at the top, and the remaining statements continue in descending order based on CPU time. This feature enables you to focus your SQL tuning efforts on the statements that can have the most impact on database performance.

Click a query 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.