Suggested spfile changes due to an increase in CPU.
All,
I now have 48 CPU’s associated with my EBS 11.2.0.2 database tier.
Based on the increase in CPU, I noted several items that I am considering to resize because of how they are calculated: LOG_BUFFER size, PARALLEL_MAX_SERVERS and PARALLEL_SERVER_TARGET.
Are there any other parameters I should look at based on the increase in CPU?
Example: I am increasing my LOG_BUFFER size: “The number of shared redo strands as ncpus/16, and the size of each strand is 128Kb * ncpus”
The size of each redo strand is 128kb * 48 = 6144
Take the size of each redo strand * the number of shared redo strands: 6144 * 3 = 18432KB.