Home > IT Answers > Database > Oracle Application or Database on its own server.
Ktharrell
0 pts.
 Oracle Application or Database on its own server.
Database, DB2, Oracle, Performance/Tuning, Windows
Which would increase performance more. Moving an Oracle demand planning and forcasting application or an Oracle database onto its own server and or a faster server? There is some debate among myself and a couple of coworkers. I feel that the workhorse of Oracle is the database and that it should be on its own server. Some other feel that it is the application doing most of the calculations and that it should move to the new, faster server. Has anyone had to deal with this or have knowledge on it?

Software/Hardware used:
ASKED: July 12, 2006  10:47 AM
UPDATED: July 14, 2006  11:51 AM
RELATED QUESTIONS
Answer Wiki:
Do you have a performance problem ? Have you measured anything to determine what the cause of performance problem is ? Seperate or faster servers only help when there's a CPU bottleneck. Ken
Last Wiki Answer Submitted:  July 13, 2006  9:43 am  by  Bozzo999   0 pts.
All Answer Wiki Contributors:  Bozzo999   0 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

The answer is, of course, “it depends”. You need to monitor both the database and application, to see if one or the other is more “needy” of resources. If BOTH happen to be equally “needy”, I would vote for the application software getting the extra resources. It doesn’t matter if you have a screaming database if your application interface is slow; the user will still see a slow response.

BJag123
 0 pts.
 

First: It’s a very good move to seperate the application server and the oracle database server.
Another ‘it depends’ is “Where is the data?” If the data is on the same server as the Oracle instance (as opposed to being on a SAN array. Note: a SAN array is expensive but offers a big improvement in I/O processing) then I’d tend to have the this on the new/faster server (epsecially ture with the 10g “self tuning” database. The application server should have plentry of memory (but not much disk). If necessary get another (low cost) application server and load balance over the 2.
If you leave the database on the existing server consider getting more memory for it and increase/re-tune the various buffer pools (keep/recycle etc).
Regards
Peter
(based on my own experience changing tower servers to rack mounted servers).

Psw2000
 0 pts.