SGA_MAX_SIZE

[manthana_c]

Dear Guru:

What should be the appropriate value for SGA_MAX_SIZE?

right now SGA_MAX_SIZE = 444m and shared_pool_size=208m.

I 'd like to set the shared_pool_size=400m but not allowed.

please advise and thanks in advance.

[Former Member]

Hi Manthana,

If you want to use dynamic SGA , you can define parameter SGA_MAX_SIZE, which sets an upper limit for the total size of the SGA. You can only increase the size of parameters, such as DB_CACHE_SIZE or SHARED_POOL_SIZE, up to the size defined by SGA_MAX_SIZE.

SGA_MAX_SIZE should be higher enough than the sum of all your memory pools of SGA (db_cache,shared_pool,redologbuffer)

Add all your SGA memory pools and set the SGA_MAX_SIZE accordingly.

Note 617416 - Oracle9i: Dynamic SGA

Br,

Venky