Re: striping , raid 5 and oracle tablespaces.

Jomathan

    You may be able to help me
    We are running raid 0+1 also.
    We are using Oracle 8.0.5 on Digital Unix 4.0d     We are experiencing what apperars to be though-put problems.     We are trying to insert 300 records per second using a 'C' program. We can only achieve about 140.

     We have 5 disks to write to. We are inserting to one table a 200 byte record with a primary key index.

     We absolutely have to insert one record at a time. We have changed init.ora parameters, stripped the files
and just about anything else you can think of. We are not sure Oracle can write this fast with single record input. We were able to get much more through-put with 'C' and array processing, but again, we cannot use array processing.

      Do you have any experiences you can share or help

Thanks a million
Harry Brewster
hbrewst1_at_tampabay.rr.com
Oracle DBA

Jonathan Gennick wrote:

> On Wed, 21 Jul 1999 10:51:16 +0200, "Jean-Marc Pouchoulon"
> <jean-marc.pouchoulon_at_crit.univ-montp2.fr> wrote:
>
> >I try to improve perf for oracle on an AIX 421 system, oracle 734
> >I saw in the archives that raid 5 is adapted for oracle only for 10-20 users
> >and for tablespaces that read access is considerable.
>
> We use RAID 1+0 instead of RAID 5 because we don't want the
> overhead of maintaining the parity. We are blessed with
> many, many, many disks, so we can afford to do this.
>
> >On the other hand, people recommand me to put tablespaces on separate disks
> >( one for index, the other for data ...) rather then striped the tablespaces
> >on x disks. Any comment ?
>
> You can do both. I have one database where I have a 16gig
> RAID 1+0 set for tables and another of the same size for
> indexes.
>
> If you're going to change things around, try and identify
> some things you can use as metrics first. If you have some
> long-running batch jobs, time them before and after to
> verify that you have made a difference. You really need
> something to measure. I tend to focus on job run times and
> other things that are noticible to the users.
>
> Jonathan
>
> _____________________________________________________
> jonathan_at_gennick.com
> http://gennick.com
> Brighten the Corner Where You Are
Received on Fri Jul 23 1999 - 18:45:41 CDT