RE: Performance issue - Not sure if its disk or some thing - How can I narrow down this

Hi All,

        I'll like to unsuscribe from this list, I try it before but it didn't work, any one can tell me how can I do it?

thanks in advanced

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Alexander Fatkulin Sent: Martes, 04 de Diciembre de 2007 12:38 p.m. To: bnsarma_at_gmail.com
Cc: oracle-l_at_freelists.org
Subject: Re: Performance issue - Not sure if its disk or some thing - How can I narrow down this

trace your quires using 10046 level trace with waits and see how much time you do really spend on I/O

>
> Should I go behind Tuning the Queries or Storage, spreading datafiles
> across multiple disks.
>
> Apprecaite your thoughts
>
>
>
>
>
>
> --
> Regards & Thanks
> BN

--
Alex Fatkulin,
The Pythian Group,
http://www.pythian.com/blogs/author/alexf
--
http://www.freelists.org/webpage/oracle-l


--
http://www.freelists.org/webpage/oracle-l