Database Tuning (MOSC)

MOSC Banner

What is the best way to determine initial values for the cpu_count parameter?

in Database Tuning (MOSC) 3 commentsAnswered ✓

Oracle Database 19c Enterprise Edition Release 19.0.0.0.0

Oracle Linux Server 7.7

We currently have 20+ databases running on a single linux host (1 host per environment: dev/test/prod) and will be migrating to new hardware in the coming months. We would like to leverage instance caging by setting the cpu_count variable to an appropriate value in each instance when we migrate.

My question is: What is the best way to determine an initial cpu_count value for each individual database? What metrics should this be based off of? And where would I find them?


TL;DR more background:

I have been digging through various articles, blog posts, questions on this forum, white papers, and support docs/manuals for several days now, and while I've found plenty of information on how to set cpu_count and perform instance caging on a conceptual level, I've yet to find a definitive answer on how to determine an initial value for cpu_count based on previous/existing performance metrics.

Tagged:

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

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center