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: Oracle IO tuning tips/practices on Windows

Re: Oracle IO tuning tips/practices on Windows

From: Joel Garry <joel-garry_at_home.com>
Date: 1 Feb 2006 16:26:31 -0800
Message-ID: <1138839991.094763.164290@g43g2000cwa.googlegroups.com>


>seems ike it's spending too much time on IO.

Is it? Remember, db file sequential read is random access (great semantics, eh? Well, it could be getting blocks one at a time in an FTS...). Is the 80M/sec figure random access? http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96533/instance_tune.htm#15959

This is the sort of thing voodoo tuners love, because often the problem can be morphed by simply enlarging the SGA or using the various buffer pools without determining actual cause. Then you get cpu bound and throw more hardware at it!

So, what is your cpu_multiblock_count, and why do you think changing it would help? See
http://groups.google.com/group/comp.databases.oracle.server/browse_thread/thread/2f1e21ecdaca8331/25807a324350e834?lnk=st&q=insubject%3AMulti-Block+insubject%3Aread+insubject%3Acount&rnum=1&hl=en#25807a324350e834

jg

--
@home.com is bogus.  Q -How do you get your technology work done, when
your IT department is more hindrance than help?  A- You don't. You fire
them and outsource their jobs to India.
http://ask.slashdot.org/askslashdot/06/02/01/2117240.shtml
Received on Wed Feb 01 2006 - 18:26:31 CST

Original text of this message

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