Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Performance issue - Not sure if its disk or some thing - How can I narrow down this

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

From: Alexander Fatkulin <afatkulin_at_gmail.com>
Date: Tue, 4 Dec 2007 13:37:39 -0500
Message-ID: <49d668000712041037y1b02096gbdf93a2bf1ab50f6@mail.gmail.com> 





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


Received on Tue Dec 04 2007 - 12:37:39 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US