Database Tuning (MOSC)

MOSC Banner

Suggested spfile changes due to an increase in CPU.

edited Apr 28, 2014 7:25PM in Database Tuning (MOSC) 4 commentsAnswered

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center