Oracle Application or Database on its own server.

pts.
Tags:
Database
IBM DB2
Microsoft Windows
Oracle
Performance/Tuning
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?

Answer Wiki

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

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

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
  • BJag123
    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.
    0 pointsBadges:
    report
  • Psw2000
    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).
    0 pointsBadges:
    report
  • Ktharrell
    [...] Address: http://itknowledgeexchange.techtarget.com/itanswers/oracle-application-or-database-on-its-own-server... (0) Comments Read [...]
    0 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