Professional Web Applications Themes

RAID 1 vs RAID 0/1 - AIX

[email]ucstylehotmail.com[/email] (Ken) wrote in message news:<d526473a.0306260607.7a0c3c49posting.google. com>... > [email]ucstylehotmail.com[/email] (Ken) wrote in message news:<d526473a.0306160838.74d71dcaposting.google. com>... > > Thanks, > > > > The idea with doing RAID 1 on the servers was to eliminate having a > > RAID 0/1 and having difficulty with adding disk, etc. We're thinking > > RAID 1 will make maintenance a little and have Oracle handle how it > > writes data to the disk. > > > > Has this practice been used and has has it functioned (hot disk, high > > I/O, etc) > > > > THanks > > > ...

  1. #1

    Default Re: RAID 1 vs RAID 0/1

    [email]ucstylehotmail.com[/email] (Ken) wrote in message news:<d526473a.0306260607.7a0c3c49posting.google. com>...
    > [email]ucstylehotmail.com[/email] (Ken) wrote in message news:<d526473a.0306160838.74d71dcaposting.google. com>...
    > > Thanks,
    > >
    > > The idea with doing RAID 1 on the servers was to eliminate having a
    > > RAID 0/1 and having difficulty with adding disk, etc. We're thinking
    > > RAID 1 will make maintenance a little and have Oracle handle how it
    > > writes data to the disk.
    > >
    > > Has this practice been used and has has it functioned (hot disk, high
    > > I/O, etc)
    > >
    > > THanks
    > >
    > > "Gerd Walther" <gerd.walthert-online.de> wrote in message news:<bchihr$35t$01$1news.t-online.com>...
    > > > Hallo,
    > > >
    > > > Oracle cannot stripe for the system.
    > > > Oracle striping is only a distribution of datablocks on several disks but no
    > > > striping.
    > > > At first you must create more then one datafile on difference disks. Then
    > > > the
    > > > min extent storage clause must defined as 2. Then Oracle writes at first
    > > > one datablock
    > > > in the first extent in the first datafile on the first drive and then in the
    > > > other extent in ......
    > > > So you can minimize hot spots , but it is not real striping.
    > > >
    > > > Better for performace ist real striping with AIX and the mirroring but it
    > > > isn't cheaper.
    > > >
    > > > Best regards
    > > >
    > > > Gerd
    > > >
    > > > "Ken" <ucstylehotmail.com> schrieb im Newsbeitrag
    > > > news:d526473a.0306120858.5254cfb2posting.google.c om...
    > > > > AIXers,
    > > > >
    > > > > Has anyone out here have a system configuration where Oracle handles
    > > > > the striping across the drives while the system just handles Mirroring
    > > > > across the drives??
    > > > >
    > > > > I'm working with the DBA and he's wanting to have Oracle do the
    > > > > striping and the system just does the mirroring?? If so, does anyone
    > > > > have any feedback on this??
    >
    > THANKS,
    > So have you ever ran oracle on a system that's RAID 1? do you have any
    > system performance stats? We're looking at this, understand that it's
    > not RAID 0 (in the AIX sence), is there high I/O during sequential
    > read/writes??
    Hi Ken,

    we have a CRM system (SAP) running on a Oracle DB.(A huge amount of
    I/O)
    The system was running with RAID 1 (LVM Mirror) for about a year and
    we always had problems with Disk I/O.
    3 Month ago we changed the Oracle Datafiles to RAID 10. All LV's
    striped over 10 Disks and mirrored to 10 other disks (all SSA Disks).
    We have improved our Disk I/O enormously. (Avrg I/O time from 100-200
    ms to 10-20 ms).

    regards
    Axel
    Axel Schneider Guest

  2. #2

    Default Re: RAID 1 vs RAID 0/1

    [email]axelschegmx.de[/email] (Axel Schneider) wrote in message news:<c70d3212.0306262336.46dd300eposting.google. com>...
    > [email]ucstylehotmail.com[/email] (Ken) wrote in message news:<d526473a.0306260607.7a0c3c49posting.google. com>...
    > > [email]ucstylehotmail.com[/email] (Ken) wrote in message news:<d526473a.0306160838.74d71dcaposting.google. com>...
    > > > Thanks,
    > > >
    > > > The idea with doing RAID 1 on the servers was to eliminate having a
    > > > RAID 0/1 and having difficulty with adding disk, etc. We're thinking
    > > > RAID 1 will make maintenance a little and have Oracle handle how it
    > > > writes data to the disk.
    > > >
    > > > Has this practice been used and has has it functioned (hot disk, high
    > > > I/O, etc)
    > > >
    > > > THanks
    > > >
    > > > "Gerd Walther" <gerd.walthert-online.de> wrote in message news:<bchihr$35t$01$1news.t-online.com>...
    > > > > Hallo,
    > > > >
    > > > > Oracle cannot stripe for the system.
    > > > > Oracle striping is only a distribution of datablocks on several disks but no
    > > > > striping.
    > > > > At first you must create more then one datafile on difference disks. Then
    > > > > the
    > > > > min extent storage clause must defined as 2. Then Oracle writes at first
    > > > > one datablock
    > > > > in the first extent in the first datafile on the first drive and then in the
    > > > > other extent in ......
    > > > > So you can minimize hot spots , but it is not real striping.
    > > > >
    > > > > Better for performace ist real striping with AIX and the mirroring but it
    > > > > isn't cheaper.
    > > > >
    > > > > Best regards
    > > > >
    > > > > Gerd
    > > > >
    > > > > "Ken" <ucstylehotmail.com> schrieb im Newsbeitrag
    > > > > news:d526473a.0306120858.5254cfb2posting.google.c om...
    > > > > > AIXers,
    > > > > >
    > > > > > Has anyone out here have a system configuration where Oracle handles
    > > > > > the striping across the drives while the system just handles Mirroring
    > > > > > across the drives??
    > > > > >
    > > > > > I'm working with the DBA and he's wanting to have Oracle do the
    > > > > > striping and the system just does the mirroring?? If so, does anyone
    > > > > > have any feedback on this??
    > >
    > > THANKS,
    > > So have you ever ran oracle on a system that's RAID 1? do you have any
    > > system performance stats? We're looking at this, understand that it's
    > > not RAID 0 (in the AIX sence), is there high I/O during sequential
    > > read/writes??
    >
    > Hi Ken,
    >
    > we have a CRM system (SAP) running on a Oracle DB.(A huge amount of
    > I/O)
    > The system was running with RAID 1 (LVM Mirror) for about a year and
    > we always had problems with Disk I/O.
    > 3 Month ago we changed the Oracle Datafiles to RAID 10. All LV's
    > striped over 10 Disks and mirrored to 10 other disks (all SSA Disks).
    > We have improved our Disk I/O enormously. (Avrg I/O time from 100-200
    > ms to 10-20 ms).
    >
    > regards
    > Axel

    Thanks Axel,

    Were you running Oracle using Oracle in a pseudo striping capacity?
    I've never seen this configuration but my DBA is bent that it (Oracle)
    can handle the placement of the datafiles across multiple disk and in
    essence have some form of striping. We have a RAID 0/1 on 6 drives now
    that we use for data files. Do you remember the numbers with your high
    I/O on average??

    thanks
    Ken Guest

Similar Threads

  1. raid on emc
    By utkanbir in forum Informix
    Replies: 2
    Last Post: September 9th, 05:57 AM
  2. [linux-raid] Problem converting raid-5 array from 2.2.17 into 2.4.22
    By John Doe in forum Linux Setup, Configuration & Administration
    Replies: 0
    Last Post: September 2nd, 10:37 PM
  3. raid 0
    By curt carnemark in forum Adobe Photoshop 7, CS, CS2 & CS3
    Replies: 1
    Last Post: August 22nd, 12:44 PM
  4. Looking for RAID
    By Doug Laidlaw in forum Linux Setup, Configuration & Administration
    Replies: 1
    Last Post: August 6th, 11:36 PM
  5. RAID?
    By Vikki Roemer in forum Debian
    Replies: 10
    Last Post: July 7th, 04:30 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139