Oracle SGA Parameters

[Former Member]

Hi There.

If someone says, Change oracle SGA Parameters? What are the Parameters are they talking about?

Can someone please let me know the parameters?

Thanks

Kumar

[Former Member]

Hi,

In addition :

db_cache_size

db_keep_cache_size

db_recycle_cache_size

large_pool_size

log_buffer

shared_pool_size

sort_area_size

hash_area_size

pga_aggregate_target

sga_max_size

Pl award suitably.

Regards

[Former Member]

Hi Kumar

Just ask the 'someone' which parameter should be changed to which value. You really should do this. It is just impossible to answer a general question like this, without even knowing your Oracle version.

However, i can give you some general hints. SGA is the main shared memory structure of an Oracle database. The two most important parts are the buffer cache, which is the cache for the data blocks, e.g. table and index data. The other is the shared pool, where dictionary information, access plans and a lot more are stored.

The most important parameters are <b>shared_pool_size, db_cache_size</b> and <b>sga_max_size</b>. I suggest again, to go back to the person and ask what he was thinking about. Also check sap note 830576 - Parameter recommendations for Oracle 10g.

Best regards

Michael