Hands-On 12 (Obtaining a SQL statement Information using OEM)

As a DBA, you are responsible for obtaining SQL statement information for performance tuning purposes. The following is a summary of your task:

1. Selecting a target database

2. Obtaining the “Disk Reads Per Execution” output

3. Obtaining the “Buffer Gets Per Execution” output

4. Obtaining the “Execution” output

5. Obtaining the “Disk Reads” output

6. Obtaining the “Buffer Gets” output

7. Obtaining the “Hit Ratio” output

Hands-On 12 (Obtaining a SQL statement Information using OEM)

Description:

In this exercise you will learn how to get information about SQL statements
such as "Disk Reads per Execution," "Buffer Gets Per Execution," 
"Executions," "Disk Reads," "Buffer Gets," and etc from the "Top SQL" tool
using the Oracle Enterprise Management tools (OEM).

==Start.
Expand the Databases item.

==
Select the DBS4RMAN database.

==
Go to the "Diagnostics Pack" tool and click on the "Top SQL" icon.

==
Double click on the "DELETE from test" statement.
You can get:
"Disk Reads Per Execution,"
"Buffer Gets Per Execution,"
"Executions,"
"Disk Reads,"
"Buffer Gets,"
"Hit Ratio" and etc. As you can see there, is a lot of information that can 
be viewed from this window.

We already have a job running in the background and the job is in the loop.

==
Close the window.

==
Do the same for the other SQL statements.

==
Close the window.

==
Then, close the "Top SQL" window without saving the chart option.

==
Suppress the expanded item.

We assume that you already know what the "Disk Reads," "Buffer Gets,"
and "Hit Ratio" are.


==

For more information about the subject, you are encouraged
to read from a wide selection of available books.

Good Luck!