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.
No comments:
Post a Comment