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