Fwd: Hard Disk selections

• Forwarded message ---------- From: Denys van Kempen <dvkempen_at_gmail.com> Date: Sep 22, 2005 2:11 PM Subject: Re: Hard Disk selections To: bunjibry_at_gmail.com

Bryan,

Read
http://www.oracle.com/technology/deploy/performance/pdf/opt_storage_conf.pdffor an introduction to the topic. It explains quite well the problem with disks getting bigger (more data) but not getting much faster (I/O throughput). The HP/Oracle whitepaper
http://www.oracle.com/technology/deploy/availability/pdf/SAME_HP_WP_112002.pdfgives some return from the field.

Oracle uses 42 * 36GB disks for an Oracle Applications standard benchmark on the IBM FastT
http://www.oracle.com/apps_benchmark/html/0440A_Report1.html

Ever wondered why the number 1 TPC benchmark configuration uses 6400 (36.4GB) disks?

http://www.tpc.org/tpcc/results/tpcc_perf_results.asp Select System link and then Executive Summary for system configuration. Some examples:
http://www.tpc.org/results/individual_results/IBM/IBM_595_64_20041118_ES.pdf http://www.tpc.org/results/individual_results/HP/HP%20Integrity%20rx5670%20Cluster%2064P_ES.pdf

Regards,

Denys

On 9/22/05, Bryan Wells <bunjibry_at_gmail.com> wrote:
>
> Let me apologize in advance if i leave any good facts out and have to
> restate...
> I am in process of migrating an existing windows 2k, 9.2.0.5<http://9.2.0.5>test environment to some beefier hardware attached to IBM FastT SAN (?). The
> current environment is a Dell Poweredge 6400 p3 4x500 MHz/ with internal and
> external disk being 76GB 15k RAID 5. The new environment will be a blade
> with 2x2.5Ghz, at least, attached to the san. My question; will
> performance, Oracle that is, suffer going with a bigger disk (146Gb) on the
> SAN, or should I stay with the 76GB disk? The requirement is to not allow
> the performance to degrade below the existing SLA, however, we will have
> more users hitting this test instance once the cut over has been made.
> Because the hardware will not be over 4+ years old, my gut feel is that the
> bigger disk should not be an issue in this type of environment any more than
> that seen with the 76Gb in the existing environment, however, how do I prove
> this?
> Any links to help Green DBA Man understand Oracle and disk selections?
> As always, thanks for your help and patience.
>
> --
> Bryan Wells
> bunjibry_at_gmail.com
> Oracle DBA hopeful
>

--
http://www.freelists.org/webpage/oracle-l