How number of processors correlated to Oracle database size

25 pts.
Tags:
Oracle on Linux
Oracle performance
Unix Server sizing
Unix Servers
Is there a guideline to determine how many processors to use (in unix OS) according to the Oracle database size?

Answer Wiki

Thanks. We'll let you know when a new response is added.

I don’t know of such a guideline, and I don’t think you should determine the number of processors based on the database size. I would look for metrics like transactions/operations per second, or something like that.

A small database could demand more CPU than a much bigger one, depending on the amount of operations it needs to handle. I think the size of the database should at most be used in conjunction with some other and more important (for this specific purpose) values such as transactions per second.

—————————————–

Discuss This Question: 3  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • 626
    I agreed that the no of transactions per second to be processed is important in determining the number of processors. I have a large number of transactions to be processed within a certain period of time (during night, e.g. 6 hours). I couldn’t find any benchmark I can use to compare or estimate. I am wondering how IT people decide what hardware to use if they know the size of database or number of transactions they are going to deal with.
    25 pointsBadges:
    report
  • carlosdl
    I found this Capacity Planning guide. Take a look at it to see if it helps. Although it was written for Oracle Internet Directory, I think similar concepts could be applied to a database server. I think most people determine their CPU needs by looking at previous CPU usage statistics, mainly at peak usage times.
    69,065 pointsBadges:
    report
  • 626
    That is a great reference. Thank you.
    25 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following