Hello,
I've been reading up on memory allocation and just want some clarification on my thinking and understanding of it. I'm running an Oracle 11.2.0.3 Database on a Windows 2008R2 physical server with 64GB RAM. From what I have read I plan to distribute memory in the following manner:
Windows OS should be given 20% so 12.8GB rounded to 13GB gives me 51GB left to play with.
PGA should be (bitmap_merge_area_size + hash_area_size + sort_area_size) * 'max number of connections'
SGA can be whats left over.
Does the memory_max_target parameter need to be set at a value that is equal to the PGA + the SGA?
Any help is great
Thankyou