Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> 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..."Received on Fri Jan 11 2002 - 14:54:22 CST