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: Approximately sizing SGA

Re: Approximately sizing SGA

From: Joel Garry <joel-garry_at_home.com>
Date: 16 Dec 2004 13:26:24 -0800
Message-ID: <1103232384.021331.54460@c13g2000cwb.googlegroups.com>


>> 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).

jg

--
@home.com is bogus.
Dude!  http://www.pitt.edu/~kiesling/dude/dude.pdf
Received on Thu Dec 16 2004 - 15:26:24 CST

Original text of this message

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