Since 1999     References  |  Search more  | Oracle Syntax  | Free Online Oracle Training

    Home      .Services     Login       Start Learning     Certification      .                 .Share your BELIEF(s)...


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



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



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


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


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.