Isn't 160 MB no good? Oracle Docs say 128 MB is good enough!!!! I am talking
about 8.1.6 database and not 9i
Connor McDonald <connor_mcdonald_at_yahoo.com> wrote in message
news:3C3F50FE.38CC_at_yahoo.com...
> Ian Terence Botham wrote:
> >
> > I just installed a new Oracle 8.1.6 database for my development env.
> > I would like to know the optimal initialization parameters that would
> > be fit enough even if my database expands a bit. I would be storing
> > day-to-transactions and the orders which increases gradually.
> >
> > I have a 160 MB RAM.
> >
> > How much should the SGA be?
> > What size should the shared pool, Log buffer, Data Buffer?
> >
> > Which size should be more than the otehr,, for an optimal perfomance?
> >
> > Any ideas are well appreciated...
> >
> > Thanks
> > Botham
>
> Probably first thing would be to jump down to www.crucial.com and pick
> up another 256M to take you to something feasible to work with.
>
> Then (for a very rough rule of thumb), look at giving 25-50% of that to
> your SGA.
>
> hth
> connor
> --
> ==============================
> Connor McDonald
>
> http://www.oracledba.co.uk
>
> "Some days you're the pigeon, some days you're the statue..."
Received on Fri Jan 11 2002 - 17:41:32 CST
