Re: RAID5 and ORACLE

I agree. READING is much faster, WRITING a little slower. Also, you need to split your tablespaces across RAID banks instead of across disks... This can get a little tricky so make sure you understand the hardware configuration before you lay out the tablespaces.

Albert W. Dorrington (awdorrin_at_mail.delcoelect.com) wrote:

: In article <31F7829B.4B6_at_luc.ac.be>, Jan Timmermans <jtimmerm_at_luc.ac.be> writes:
: |> Hi,
: |>
: |> Can anyone give some infomation or remarks about the use of a RAID5
: |> system with an ORACLE server.
: |> We are setting up an ORACLE databank on an NT server and where wondering
: |> what the consequences would be of using RAID5: security, perfomance,

: I admin a server which runs Oracle 6 with 20GB of RAID 5
: disk arrays. Performance with the RAID arrays has not been an
: issue at all - but it all depends upon how your database will be
: accessed. If the majority of access will be READING then you may
: actually see a performance boost over standard disks. Writing may
: be a little slower.
: As for 'security' I assume you mean, how well is the data
: protected from failure, not from 'hackers'. I've lost up to two disks
: in an array without losing a single bit of data. The database just kept
: cruising along. :)
 

: - Al
 

: --
: Al Dorrington
: awdorrin_at_ictest.delcoelect.com Database Admin
: Delco Electronics - IC CIM Unix Sysadmin
: Kokomo, Indiana, USA Phone: 317.451.9655

--
    ..uu.                                     ----------------------
  .?$" '?i     .                              I  Randy DeWoolfson  I
 .T^M  ._at_"    d9    .     f   ,.un.  b,    i  I--------------------I
 "  Z :#"    M `8   U    <  .dP"``"# `M   _at_"  I  randyd_at_cais.com   I
    &H?`    Xl _R   $5.  $  ?*    _at_   'P,#"   I--------------------I
  ,d#^*L   :RP'~$b  f`$L:M  Xf  .f'    dH`    I        ,\//.       I
    &  'M ,P    `E  M   "$  Mux~      n!`     I        |o o|       I
   dk   `h"       ' j     " y"       *~       I====oOO==(_)==Ooo===I