As a best practice, allocate 65% of total VM memory to SGA and PGA. Make sure the memory of SGA is triple the memory of PGA. This best practice uses VMs with 128 GB of memory.
If data disks with cache disks are used, allocate memory according to Table-1.
Table-1 SGA and PGA memory planning
|
Item |
Memory |
|
SGA |
62 GB (128 GB × 65% × 75%) |
|
PGA |
20 GB (128 GB × 65% × 25%) |