Re: SGA sizing recommendations

Sybrand,
Sorry if I wasn't clear enough, but the box has 12GB of physical memory, 10-11.5 of which will be available to Oracle, depending upon how much is used for swap. It will also be a 12CPU machine. I'm not looking for hand holding necessarily, but want to make sure I give Oracle a fair chance to actaully handle the task (against an In Memory Database which only scales to 2CPU's thus many more databases deployed to handle the task, but less memory requirements).

Sybrand Bakker wrote:

> You don't specify the size of your physical memory.
> How can we size your sga in that case.
> I would go for db_block_buffers upto 40M by default, but that maybe still
> insufficient.
>
> Hth,
>
> Sybrand Bakker, Oracle DBA
>
> Ihaveaquestion <Ihaveaquestion_at_yahoo.com> wrote in message
> news:38D698F2.C39DA50A_at_yahoo.com...
> > We are getting ready to benchmark an application on a Sun E45000 running
> > either Oracle 8 or preferably Oracle 8i...Solaris 2.7.
> > The actual physical database size will be small, roughly 2GB.
> > We plan to follow OFA.
> >
> > We will have approximately seven 18GB disks(can hardly find 9GB disks
> > anymore) available for this, and 12GB of memory.
> > It will need to be configured for advanced replication, and will need to
> > be in Archive log mode.
> >
> > The database will need to be able to handle approximately 12-15,000
> > updates per second.
> >
> > With this amount of memory available, we can push all of the SGA into
> > memory and keep it there.
> > This benchmark has got to be done pretty quickly and proven, and I would
> > love to be able to make it work.
> >
> > I have some ideas on how to get this to work....potentially things such
> > as
> > ensureing that contiguous blocks per write are set high, redo and
> > rollback numbers and sizing, using process slaves, multiple temporary
> > tablespaces, ISM, post-wait drivers, prepaging and locking the SGA in
> > main memory, Net 8 configs, pre-spawned dedicated server processes,
> > configuring buffer_pool_keep and recycle.....
> >
> > My main reason for posting, is ... is this even a possible task?
> >
> > Secondly, any suggestions and feedback are welcome ;-)))
> > (i.e. any configuration considerations I have missed, Oracle 8 vs 8i
> > opinions, etc.)
> >
> > TIA
> >
> >
> >
> >
Received on Mon Mar 20 2000 - 00:00:00 CST