Re: Optimal Initialization Parameters

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