How number of processors correlated to Oracle database size
Home > IT Answers > Linux > How number of processors correlated to Oracle...
626
25 pts.
0
Q:
How number of processors correlated to Oracle database size
Unix Server sizing, Oracle on Linux, Unix Servers, Oracle performance
Is there a guideline to determine how many processors to use (in unix OS) according to the Oracle database size?
ASKED: Apr 20 2009  9:16 PM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
0
Carlosdl
29805 pts.
0
A:
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
  • AddThis Social Bookmark Button
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.

-----------------------------------------
Last Answered: Apr 20 2009  10:13 PM GMT by Carlosdl   29805 pts.
  •   
0
0
RSS - Discussions Help
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

626   25 pts.  |   Apr 22 2009  3:59AM GMT

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.

 

Carlosdl   29805 pts.  |   Apr 25 2009  1:05AM GMT

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.

 

626   25 pts.  |   Apr 27 2009  3:31PM GMT

That is a great reference. Thank you.

 
0