iSelfSchooling.com  Since 1999     References  |  Search more  | Oracle Syntax  | Free Online Oracle Problem Solver

    .Home      .Subscribe     .Login      .Start Learning      .Certification      .Cancel      .Password Reminder      .Password Change     .Sign out

 

. Online Accounting        .Copyright & User Agreement   |
    .Vision      .Biography     .Acknowledgement

.Contact Us      .Comments/Suggestions       .Email2aFriend    |

 

Online Oracle Training for beginners and advanced - The most comprehensive Oracle tutorial

The authors do not guarantee or take any responsibility for the accuracy, or completeness of the information.

DBAs - OEM

 

Lesson 01 | Lesson 02 | Lesson 03 | Lesson 04 | Lesson 05 | Lesson 06 | Lesson 07 | Lesson 08 | Lesson 09 | Lesson 10 | Lesson 11 | Lesson 12 | Lesson 13 | Lesson 14 | Lesson 15 | Lesson 16 |

 

Lesson 12

"If you were plowing a field, which would you rather use? Two strong oxen or 1024 chickens?" - Seymour Cray (1925-1996), father of supercomputing

 

Read first then play the video:

   OEM-VIDEO -Obtaining a SQL Statement Information

   

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.