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
MMDGmbHAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Powerful Yet Easy-to-Use Network Monitoring

Identify excessive bandwidth utilization or unexpected application traffic with SolarWinds Bandwidth Analyzer Pack.

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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Server Hardware

From novice to tech pro — start learning today.