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 14

"Research is what I'm doing when I don't know what I'm doing." - Wernher Von Braun (1912-1977)

 

Read first then play the video:

   OEM-VIDEO -Obtaining Disk I/Os

   

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.