Host and Database Performance Monitoring - Oracle Exadata Recipes: A Problem-Solution Approach - page 412

Finally, from the Performance Home page select below the I/O load section, look at the I /O Megabytes per
Second by I/O Function and I/O Requests per Second by I/O Function sections. These portions of the main
performance page display data transfer rates and I/Os per second, broken down by the type of I/O being performed.
With Exadata, this is a great place to view the use of smart scan and graphically compare the volume and percentage
of smart scan I/O requests versus other I/O functions. Figure 14-7 displays that for a specific database we experienced
a high volume of smart scan I/O megabytes for a period of time.

Figure 14-7. I/O megabytes per second by I/O function

How It Works
Enterprise Manager 12c Cloud Control provides a feature-rich and robust set of solutions for monitoring your Oracle
Exadata Database Machine. In this recipe, we have provided a number of solutions to view specific Enterprise
Manager monitoring features for Exadata, but what we've provided is by no means exhaustive or comprehensive—the
range and depth of monitoring functionality provided by Enterprise Manager for Exadata is a broad topic and worth a
text on its own.
To learn more about monitoring Exadata with Enterprise Manager 12c Cloud Control, we recommend reading
through Oracle's documentation at www.oracle.com/technetwork/oem/exa-mgmt/exadata-mgmt-twp-1662642.pdf .

14-4. Monitoring Performance with SQL Monitoring
Problem
You wish to perform Real-Time SQL Monitoring on your Oracle 11gR2 Exadata databases in order to gain an in-depth
picture of your database's SQL workload.

Solution
In this recipe, you will learn how to use Oracle's 11g Real-Time SQL Monitoring tool to view performance information
for SQL statements running on Exadata. We will demonstrate both how to use SQL Monitoring from Enterprise
Manager as well as provide methods to use DBMS_SQLTUNE to generate SQL Monitoring reports.

■ real-time sQL monitoring is not unique to exadata; it is an oracle 11g database feature. We are including a
sQL monitoring recipe in this chapter because of its applicability to the topic of performance optimization on exadata.
We believe real-time sQL monitoring is one of the best features introduced into oracle 11g and with exadata's “extreme
performance” promise, provides the best method for visualizing your oracle sQL statement performance behavior.

Note