Performance Pages and ASH Analytics - Expert Oracle Enterprise Manager 12c - page 307

Figure 9-13. Top SQL and Top Sessions, demonstrating an I/O issue in a database environment
Top SQL Pane
The Top SQL section is broken down by percentage of activity, SQL ID (unique identifier for the SQL statement),
and the type of SQL performed. Note that in the example shown in Figure 9-13 , an apparent high I/O resource
statement is being executed by two sessions. As the percentage is displayed against the rest of the database sessions,
the overall impact of the wait events is clearly shown.
At this point, you have the option to schedule a SQL Tuning Advisor or create a SQL tuning set from the
drop-down below the Top SQL banner. Clicking any the SQL IDs opens the SQL Details page, which provides detailed
information regarding the individual SQL statements.
SQL Details Page
The I/O issue demonstrated in SQL ID cwu5p1yyp1p40 referenced back in Figure 9-12 is actually the SQL statement
behind a tablespace data pump job. Clicking this SQL ID in the Top SQL section opens a second details page that
provides detailed information regarding performance, statistics, explain plan, tuning history, and SQL monitoring
(see Figure 9-14 ). The bottom pane of the page is controlled by a series of tabs that display different details regarding
the statement. You can inspect each tab and research the data displayed to provide value to the issue at hand. At the
top right, you can use buttons to refresh, create a SQL worksheet, perform JVM Diagnostics, or create a SQL Details
active report.
Figure 9-14. Top Activity, Top SQL details, with the example of a data pump statement, identified by SQL ID