Re: Oracle IO tuning tips/practices on Windows

NetComrade wrote:

> Their SGA size is set like this:
> db_16k_cache_size 1367343104
> db_cache_size 209715200

http://groups.google.com/group/comp.databases.oracle.server/msg/f05a24f01c03d312?dmode=source&hl=en See especially #4 and #6. I would add, if you were to put everything in the same blocksize, you might be able to make a lot better use of multiple buffer pools to shuffle around physical i/o's and SGA froth.

I'm also wondering if you are pounding on some hot blocks, resulting in those seq waits.

jg

--
@home.com is bogus.
http://www.eweek.com/article2/0,1895,1918198,00.asp