• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 513
  • Last Modified:

Oracle Server Hardware

We have to invest in a new Oracle Server Hardware and i am looking for best hardware system configuration for it. Budget is not the problem.
Requirements:
current DB Size 200 GB growing by 20% per year.
no of users: 150
Oracle Version: 11 R2
Operating System: Windows 2008 Server R2 64 bit
0
MMDGmbH
Asked:
MMDGmbH
  • 4
  • 3
1 Solution
 
Neil RussellTechnical Development LeadCommented:
The number of users and DB size is only a fraction of the information needed to properly assess the needs of the server.
Is this 150 users all concurrently accessing reports? Writing new records to the database? Updating LARGE amounts of data? etc...

The load on the database will dictate your needs and the number of users is only a very small part of that equation.

Can you give more detailed info on the application that this server is running?

Oracle state that you only need for example, 1gb of free RAM to install 11g but i wouldnt fancy running any apps on that!
0
 
MMDGmbHAuthor Commented:
per hour 1000 small dialog transaction
per week 100 big transaction (which takes 5 minutes or more each)
delphi written windows application running on windows server , report generation done locally on workstations, oracle only delivers data results for executed statements.

current server Intel Xeon * 2 processors 2,8 GHz dual core, 16 GB Memory, Memory managament done by Oracle in auto mode, generally it takes between 6-7GBs for Oracle in auto mem.
total server mem usages is 8 gbs most of the time..



0
 
Neil RussellTechnical Development LeadCommented:
I would say that the server you have currently is ample
0
Network Scalability - Handle Complex Environments

Monitor your entire network from a single platform. Free 30 Day Trial Now!

 
MMDGmbHAuthor Commented:
but the current server hardware is 5 years old, hdds are 3.5 years old.
OS is on Raid1 (10k RPM) and DB is on Raid 10 (SCSI 15k RPM)
it has redundent power supply etc. but this server is critical for organization so would like to change after 5 years and this would be used as some other servers for VM Ware.

0
 
Neil RussellTechnical Development LeadCommented:
Sorry i meant to say that the current server SPEC that you have is adequate.
If you wish to virtualise then of course that is a different matter, you did not mention that in the question.

If you are after a specific machine spec then you cant go wrong with running that on an R710 server.

http://configure.euro.dell.com/dellstore/config.aspx?oc=sv4r710&c=uk&l=en&s=bsd&cs=ukbsdt1&model_id=poweredge-r710

Customise and buy! Reliable and very very stable.
0
 
MMDGmbHAuthor Commented:
i do not want to virtualise oracle.
but once i have new server, i will use old machine to virtulise other older servers.
0
 
Neil RussellTechnical Development LeadCommented:
thats why i said it would be a different matter.........
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Improve Your Query Performance Tuning

In this FREE six-day email course, you'll learn from Janis Griffin, Database Performance Evangelist. She'll teach 12 steps that you can use to optimize your queries as much as possible and see measurable results in your work. Get started today!

  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now