Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle IO tuning tips/practices on Windows
>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.shtmlReceived on Wed Feb 01 2006 - 18:26:31 CST