Re: Striping with Oracle

We are just about to stripe our 40 gig database on a Pyramid Nile. Tests we have made show that we should see little (if any) benifits for the day to day work BUT.....

We have just gone live on Oracle 7.1.3 and it does make a large difference to parallel index build. For example, A 1 hour index build (sort in memory) can be got down to under 10 mins for a 4 disk stripe. Under 8mins for 8 disk strip. (this was for parallel seting of 5) . If no stripe was used the best I get was about 23mins.

We are going to stripe each raw disk file over 4 disks.

Regards

Nigel Noble.

John Whitney (jwhitney_at_crl.com) wrote:
: I am putting together a new SCO UNIX box for Oracle7, having come from
: the Netware environment. We are only going to have a few (5 or less)
: gigabytes of required disk space. I am interested in protecting the data
: using duplexing, although I understand the duplexing options available on
: SCO UNIX are not quite as robust as the Netware environment. After
: talking with one of the vedors who provides duplexing software, striping
: came up in the conversation. I am new to striping, but I think I have a
: pretty good idea of how it works. Are there really performance gains with
: striping? What about recovering Oracle data files on striped drives? If
: we did not stripe, we would apply the OFA specifications and tune the
: system ourselves. I would appreciate any comments from people who have had
: good/bad experiences with striping.
 

: Thanks in advance!

--
                                  _____________
    Nigel Noble                       churchill        Tel: +44 81 313 5677
    Database Administrator        =============        Fax: +44 81 313 5699
    Churchill Technology Ltd
    15-17 London Rd, Bromley BR1 1DE, UK.    Email: nigel_at_churchill.co.uk