I would like to find out which databases/processes are using which disk group. I was notified that our Disk I/O was starting to get pretty high. I'm on a Solaris box (Sun - Fire 15000) running Solaris 10.
closed as not a real question by Ward, Adrian, Scott Pack, John Gardeniers, Brent Pabst Oct 18 '12 at 15:03
It's difficult to tell what is being asked here. This question is ambiguous, vague, incomplete, overly broad, or rhetorical and cannot be reasonably answered in its current form. For help clarifying this question so that it can be reopened, see the FAQ.
Lucky for you, you're using Solaris so you can use
Show bytes read by process:
Show bytes written by process:
Show files opened by process:
Find which disks are busy:
You'll have to interpret the data a bit yourself, but using the first two commands you can see which processes are using a lot of I/O. Use the third to see which files are being opened frequently, and thereby the zpool that contains them. Correlate this with
With a bit of skill and practice you can create a