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

Home -> Community -> Usenet -> c.d.o.server -> Re: SQL tuning nightmare - db file sequential reads

Re: SQL tuning nightmare - db file sequential reads

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Tue, 04 Jul 2006 19:54:49 +0200
Message-ID: <goala2l7uhei4g8fvekua5pbckgf5g96dp@4ax.com> 





On 4 Jul 2006 10:10:19 -0700, joshic75_at_gmail.com wrote:



>The hardware is quite powerful with 24 CPUs, 16GB RAM , SAN storage

>etc. So I doubt that it will be a problem at the OS level.





Or someone subscribes to the 'More is better' tuning methodology.
That methodology is poweful enough to bring any server on it's knees.
You are sure you are not incurring 'buffer busy waits' on exactly that
block?


--
Sybrand Bakker, Senior Oracle DBA


Received on Tue Jul 04 2006 - 12:54:49 CDT












Original text of this message













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