Tracking down disk IO
I'm practicing my troubleshooting skills, specifically, pinpointing which disks/files are getting accessed at any one point in time.
We have an oracle database; if I tell the database to gather statistics it can flex the system as a whole. Anway, I wanted to see if I could pinpoint disk activity. If I kick off the gather stats call and then execute
$ iostat -xtc
devicer/sw/skr/skw/s wait actv svc_t %w %b tin tout us sy wt id
[snip]
sd75 0.05.50.2 1157.8 0.0 0.123.607
[snip]
How do I map sd75 to an actual harddrive? Or is there a better way to pinpoint which disks (even inodes?) are most active
This example is from Solaris 10, which houses our "playground" but I'd need it for Solaris 8, which is production (so I assume DTrace is out for Solaris 8).
Of course, production is running Veritas Volume Manger w/ Oracle option ... but I figured I'd get the basics down first.
