Tuesday, December 23, 2008

pga_aggregate_target and db_cache_size

In his blog article Analysing Statspack(8), Jonathan Lewis has talked about 2 rules:

pga_aggregate_target - A comfortable figure for an OLTP system would be in the 2M - 4M range per process.

db_cache_size - is always at least as large as 1M per process.

Take a note first and check reason later.