Fuser is not much helpful. In solaris 10 dtrace might help.
The best way, if you are only running database on that box, is to do a
snapshot of v$sessio or v$sesstat, and compare the sesstat difference after
another snapshot, to find out:
which session;
which sql
is using most of the disk read/write.
On 10/19/06, David Sharples <davidsharples_at_gmail.com> wrote:
>
> look in the fstab to see what is mounted on the device
>
> On 19/10/06, Hameed, Amir <Amir.Hameed_at_xerox.com> wrote:
> >
> > But how do I go in reverse direction? For example, I see that device
> > c5t31d72s3 has high service times all the times then how would I tie it
> > back to the processes using it?
>
>
--
Regards
Zhu Chao
www.cnoug.org
--
http://www.freelists.org/webpage/oracle-l
Received on Thu Oct 19 2006 - 12:43:35 CDT
