Re: Sizing SGA on sun e450

Configuring and tuning an SGAs components requires a lot more than just how much RAM do you have.

I'd start out with the generic steps used to tune an instance based on statistics stored in the V_$ views and the hundreds, if not thousands, of tuning scripts available on the web, in books, and provided by Oracle.

Daniel Morgan

Joshua Goodstein wrote:

> I have a e450 2 proc 2GB memory running oracle 8.1.7.x with four
> instances. I am trying to balance the sga for all of these instances
> as follows:
>
> instance1 768M SGA
> instance2 512M SGA
> instance3 256M SGA
> Instance4 126M SGA
>
> What values/ equation do I use too decide the following parameters:
>
> db_block_buffers
> shared_pool_size
> large_pool_size
> java_pool_size (not an essential entry curently set to 0)
> log_buffer
>
> So that they equal the above listed values. I tried using DBA Studio,
> but that seems to store it's own init<sid> file internally and does
> not kick back the settings. I understand that different variatons of
> theses values will yeild the same result. but I'm looking for what
> some of you guys do to calculate this stuff. None of these instances
> are what I would consider high traffic (< 1 million rows a day)
>
> thanks in advance
> -J
Received on Thu Feb 21 2002 - 16:46:35 CST