Optimal Initialization Parameters

From: Ian Terence Botham <botham_ian_at_hotmail.com>
Date: 11 Jan 2002 10:30:26 -0800
Message-ID: <709f185b.0201111030.2d261818@posting.google.com>

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 Received on Fri Jan 11 2002 - 12:30:26 CST