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 # 14

Next >>


 

Obtaining Disk I/Os using OEM

 

Introduction

As a DBA, you are responsible for obtaining disk I/Os for performance tuning purposes. The following is a summary of your assigned task:

Covers:

Using the �Performance Manager� tool

Selecting a target database

Obtaining disk I/Os

Using the �File Read Operations� chart

Changing the �Refresh Rate� option

Monitoring the �Physical Reads/Sec� activity

Monitoring the �Physical Block Reads/Sec� activity

 

Hands-on
In this exercise you will learn how to check the I/O activity on a disk from the "Performance Manager" tool using the Oracle Enterprise Management tool (OEM).

Expand the databases item.

Select the DBS4RMAN database.

Go to the "Diagnostics Pack" tools and click on the "Performance Manager" icon to check the I/O database.

On the "Predefined Displays" window, select the "File Read Operations" chart and click on the "Show Chart" button.

On the "File Read Operations" screen, change the "Refresh Rate" from 15 seconds to 1 second.

We wrote a procedure in the background that generates lots of I/O's in the SYSTEM tablespace.

See how much activity is in that datafile.

Check on the "Physical Reads/Sec" and "Physical Block Reads/Sec."

That's why you should monitor I/O activities to distribute the I/O evenly among your disk.

Close the window with no save chart option.

Close the "Oracle Performance Manager" tool.

Now, the SYSTEM user has an exclusive lock with no holding request lock. Well down and happy customers.

 

     Reviews and Templates for FrontPage
     

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