| |
 |
|
ss
Oracle Tips by Burleson |
Extending STATSPACK for Disk
I/O Data
Our data collection approach relies on I/O
information from Oracle and from the physical disks. We will start
by using existing STATSPACK tables, but we will also extend
STATSPACK to add the disk I/O information. We will use the UNIX
iostat utility to capture detailed disk I/O because almost every
dialect of UNIX has the iostat utility. However, there is a dialect
issue. Just as vmstat has different dialects, iostat is slightly
different in each version of UNIX, and the Oracle DBA will need to
customize a data collection mechanism according to his or her
requirements. Even within the same dialect, there are arguments that
can be passed to the iostat utility that change the output display.
|
Download your Oracle scripts now:
www.oracle-script.com
The
definitive Oracle Script collection for every Oracle professional DBA
|
|
