Skip to Main Content

Infrastructure Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

how to monitor queue length and service time for disk

807557Aug 7 2009 — edited Aug 8 2009
hi all
I try to find out how busy is the device allocated to database.
My problem is that the device which I use for database and device names reported by iostat or sar are different and I can not relate tools output to devices of my particular interest.

Here is an example:
Sybase uses device with os name: /dev/rdsk/emcpower2a
When I run iostat -xtc, I get next output:

iostat -xtr
extended device statistics,tty
device,r/s,w/s,kr/s,kw/s,wait,actv,svc_t,%w,%b,,tin,tout
md0,0.1,2.0,1.8,4.5,0.0,0.0,18.2,0,1,0,1
md1,0.0,0.0,0.0,0.0,0.0,0.0,10.9,0,0
md3,3.3,1.9,238.8,208.9,0.0,0.1,9.9,0,2
md4,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0,0
md5,0.0,0.0,0.0,0.0,0.0,0.0,0.0,0,0
...
First column of this output does not show any device with name 'emcpower2a'.

When I run: sar -d , I am having similar problem (output below).
So how can I find out performance metrics on the device I am using for my db?


sar -d 1

SunOS crdprod2 5.10 Generic_137111-08 sun4us 08/07/2009

16:14:58 device %busy avque r+w/s blks/s avwait avserv

16:14:59 md0 0 0.0 0 0 0.0 0.0
md1 0 0.0 0 0 0.0 0.0
md3 0 0.0 0 0 0.0 0.0
md4 0 0.0 0 0 0.0 0.0
md5 0 0.0 0 0 0.0 0.0
md6 0 0.0 0 0 0.0 0.0
md7 0 0.0 0 0 0.0 0.0

Can you help please
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 5 2009
Added on Aug 7 2009
2 comments
265 views