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

  • From: "Alexander Fatkulin" <afatkulin@xxxxxxxxx>
  • To: bnsarma@xxxxxxxxx
  • Date: Tue, 4 Dec 2007 13:37:39 -0500

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
--
//www.freelists.org/webpage/oracle-l


Other related posts: