Re: Approximately sizing SGA

From: iloadmin <ilo_at_ilo-infosystems.us>
Date: 17 Dec 2004 17:26:44 -0800
Message-ID: <1103333204.236240.23890@c13g2000cwb.googlegroups.com>

Howard J. Rogers wrote:
> 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
I want to thank all of you for your advice.

iloadmin Received on Fri Dec 17 2004 - 19:26:44 CST