topic Oracle 10g Hardware Sizing in Operating System - Linux

Oracle 10g Hardware Sizing

U.SivaKumar_2 — Wed, 26 May 2004 23:33:13 GMT

Hi ,

Can you provide links for documents or tools to decide on Server Sizing for running Oracle 10g on Linux ?.

regards,

U.SivaKumar.

Re: Oracle 10g Hardware Sizing

Alexander M. Ermes — Thu, 27 May 2004 00:52:09 GMT

Hi there.
Do not believe, what the systems requirements tell you.
Oracle eats resources like popcorn.
Can you give us an idea, what you are going to do with this server ?
Rgds
Alexander M. Ermes

Re: Oracle 10g Hardware Sizing

U.SivaKumar_2 — Thu, 27 May 2004 02:05:05 GMT

Hi,

We want to do Server Capacity planning for a 100 GB oracle 10g database with 500 users accessing it.

regards,

U.SivaKumar

Re: Oracle 10g Hardware Sizing

Alexander M. Ermes — Thu, 27 May 2004 02:33:21 GMT

Next questions :
general usage, datawarehouse.... ?
Go for Oracle RAC for high performance,
if possible.
Try to find out, how many users will really be connected to the system at the same time.
I would suggest Proliant ML ( cluster ? ).
Rgds
Alexander M. Ermes

Re: Oracle 10g Hardware Sizing

U.SivaKumar_2 — Thu, 27 May 2004 03:23:32 GMT

Hi Alexander ,

It is for general purpose. RAC is already decided.

Please give some links or formulas or tools to decide on server hardware .

regards.

U.SivaKumar.

Re: Oracle 10g Hardware Sizing

Joseph Loo — Thu, 27 May 2004 03:46:04 GMT

hi,

please refer to

http://h18022.www1.hp.com/solutions/enterprise/highavailability/oracle/index.html

hope it helps.

regards.

Re: Oracle 10g Hardware Sizing

Ted Buis — Fri, 28 May 2004 09:41:56 GMT

Consider first whether it will be used for OLTP or datawarehousing (business intelligence). You can see then what has been done to get high benchmark numbers at www.tpc.org. Look at the executive summaries or even more detail to understand some of what they did not only to get the processing power, but also the I/O that was needed. You may find your biggest challenge isn't in coupling multiple Proliant or Integrity servers, but in making sure that your shared storage system can handle the number of I/Os necessary. Make an estimate of how many I/Os per second you will need to support the 500 users and ask HP for a system than can deliver that number. Also, for some databases, Itanium will do much better due to the 64-bit implementation of Oracle. The best TPC-C result, last I checked, was a 10g cluster of 16 4-CPU Integrity (Itanium) rx5670 servers. You mention 500 users, but are they doing updates or queries. How complex are the queries? Are they all active users? What is the think time between updates or queries?
Good luck.

Re: Oracle 10g Hardware Sizing

Steven E. Protter — Fri, 28 May 2004 12:16:08 GMT

There are actually some resource calculation formulas on the http://otn.oracle.com or http://technet.oracle.com

This is a good quote though:

Oracle eats resources like popcorn.

Revise that to like very tasty popcorn.

I'm sitting watching 10g run idle on an HP-UX box, with no users at all and its top two processes are eating half the CPU cycles on a pretty powerful dual processer rp5450 server.

Worse than that, it doesn't seem to be balancing its load across the two CPU's very well.

I anticipate performance issues ahead.

SEP

Re: Oracle 10g Hardware Sizing

renarios — Tue, 26 Apr 2005 03:54:15 GMT

Steven,

As reaction on your comments:
I see a lot of dbsnmp CPU activity (constantly) on my HP servers. This is caused by the OMS (Oracle Management Server).
Big processors are the only solution to that.
The reason that sometimes one processor does nothing and the other one is "working it's ass off" is because Oracle assings one processor per thread.
Cheers,

Renarios

Re: Oracle 10g Hardware Sizing

Florian Heigl (new acc) — Mon, 02 May 2005 10:50:30 GMT

@renarios:

I'm only on the hp-ux, not oracle side of our systems, but on 11.11/oracle9 I also saw many issues regarding dbsnmp which by now have dissapeared, either due to version upgrade to 9.2.0.4 or some hotfix.

Maybe You can find something regarding that.

Re: Oracle 10g Hardware Sizing

Julio Yamawaki — Mon, 02 May 2005 16:25:13 GMT

Hi,

As a guide for you:
We have a rp3410 with 6 GB and 1 800 MHz processor.
Database has 50 GB and itÂ´s installed in JBOD 36 GB disks 15k rpm.
About 120 users and cpu hasnÂ´t reached in 100%.
Application is an ERP written in Forms.
This UNIX box has 29000 tpm.
Theoretically, you can use an DL380 with 3,4 GHz processor, but be carefull with Oracle prices.
From 1 to 2 processors you can use Oracle Standard One, about US$ 5.000/processor, from 2-4 you can use Oracle Standard Edition, US$ 15.000/processor (for RAC it has to be this one) and for above, Oracle Enterprise Edition, US$ 40.000/processor.
Sometimes itÂ´s better to use a RISC box with less processors.

Rega