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

  • From: "Guerrero, Citlali (GE, Corporate, consultant)" <citlali.guerrero@xxxxxx>
  • To: <afatkulin@xxxxxxxxx>, <bnsarma@xxxxxxxxx>
  • Date: Tue, 4 Dec 2007 14:22:30 -0500

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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Alexander Fatkulin
Sent: Martes, 04 de Diciembre de 2007 12:38 p.m.
To: bnsarma@xxxxxxxxx
Cc: oracle-l@xxxxxxxxxxxxx
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
--
//www.freelists.org/webpage/oracle-l


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


Other related posts: