Hands-On 14 (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:

1. Using the “Performance Manager” tool

2. Selecting a target database

3. Obtaining disk I/Os

4. Using the “File Read Operations” chart

5. Changing the “Refresh Rate” option

6. Monitoring the “Physical Reads/Sec” activity

7. Monitoring the “Physical Block Reads/Sec” activity

Hands-On 14 (Obtaining Disk I/Os using OEM)

Description:

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

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

==

For more information about the subject, you are encouraged
to read from a wide selection of available books.

Good Luck!