Hi Michael and ALL,
Im am confused
I thought, we already have enough settings of SGA parameters.
Just to clarify:
Set in your init.ora:
sga_target = 50G
db_cache_size = 20G
pga_aggregate_target = 20G
_realfree_heap_pagesize_hint = 262144
We only have Free -m of 70G, but the issue maybe is....we have two databases on this server PROD and DEV database.
Each having each own SGA setting.
What do I set value now if we have these two databases co-existing?