Re: Approximately sizing SGA

From: Howard J. Rogers <hjr_at_dizwell.com>
Date: Fri, 17 Dec 2004 21:26:47 +1100
Message-ID: <41c2b45a$0$1124$afc38c87@news.optusnet.com.au>

Joel Garry wrote:

>>>The db_block_size depends on the primary purpose of the db, ie OLTP

>
> or
>

>>>DW.

>
>

>>No it doesn't, not without an awful lot of qualifiers (such as direct

>
> I>/O being in the picture). We've been over it enough, I would have
> thought.
>
> Agreed. Why don't you point the OP towards a post you made not long
> ago summarizing your blocksize rules of thumb? (No offense intended by
> "rules of thumb," I just couldn't think what else to call the advice).

None taken. And none intended.

http://www.dizwell.com/html/db_block_size.html

Regards
HJR Received on Fri Dec 17 2004 - 04:26:47 CST