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