everythingOracle.bizhat.com

 

'Everything you wanted
to know about Oracle'

Training References Syntax Tell A Friend Contact Us

 

 

OEM

01 02 03 04 05 06 07 08 09 10 11 12 13 14 15 16 17
<< Previous

Chapter # 12

Next >>


 

Obtaining a SQL statement Information using OEM

 

Introduction

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

Covers:

Selecting a target database

Obtaining the �Disk Reads Per Execution� output

Obtaining the �Buffer Gets Per Execution� output

Obtaining the �Execution� output

Obtaining the �Disk Reads� output

Obtaining the �Buffer Gets� output

Obtaining the �Hit Ratio� output

 


Hands-on

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).

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.
 

 

     Reviews and Templates for FrontPage
     

Copyright � everythingOracle.bizhat.com 2006 All Rights Reserved.