Re: disk partition question

From: Audun <audunlea_at_hotmail.com>
Date: Fri, 4 May 2001 09:28:21 +0200
Message-ID: <gTsI6.5997$gX3.326879@news3.oke.nextra.no>

Hi !
Ref Oracle Tuning 'Ranking of RAID Levels Against Oracle File Types'

1=Best 5=Worst

                    RAID-level:  None  0    1  0+1  3    5
Control file performance        2    1    2    1    5    3
Redo log file performance      4    1    5    1    2    3
System tablespace perfor.      2    1    2    1    5    3
Sort segment performance     4    1    5    1    2    3
Rollback segment perfor.       2    1    2    1    5    5
Index read-only data files       2    1    2    1    5    1
Sequential read-only data f     4    1    5    1    2    3
DBWR intensive data files      1    1    2    1    5    5
Direct load-intensive data f     4    5    1    1    2    2
Data protection                      4    5    1    1    2    2

Acquisition and operating cost1 1 5 5 3 3

Audun Hansen
Oracle DBA
Norway

"Howard J. Rogers" <howardjr_at_www.com> wrote in message news:3af1e51e_at_news.iprimus.com.au...
> Also not an answer to your question, but RAID5 and RDBMSs generally go
> together like chalk and cheese. Your write performance will suffer as
> compared to a non-RAID5 implementation, which may or may not be acceptable
> and may or may not be noticeable.
>
> Regards
> HJR
>
> "Robert P. McGraw, Jr." <robert_mcgraw_at_yahoo.com> wrote in message
> news:3AF02247.A3A63B34_at_yahoo.com...
> > I am NOT an Oracle DBA but have been asked to install oracle 8.1.5 or a
> > Sun Solaris 4500 and a A1000 Disk Array. Another real DBA will do the
> > actually creation of the data base.
> >
> > I have made 1 big RAID 5 disk on the A1000 for the data bases.
> >
> > I have been told that I should use format to create the /u01
> > /u02..../u06 partions for the DB. My questions is why or why not make
> > directories like /export/oracle/u01....export/oracle/u06 and then link
> > these to /u01 /u02.../u06. It seems that having on big LUN and having
> > the links give more room for the db to expand. If I had individual
> > partitions then I am limited to the space in each partition.
> >
> > Can someone explain the pros or cons of both ways.
> >
> > Thanks
> >
> > Robert
> >
> >
> >
> >
>
>
Received on Fri May 04 2001 - 02:28:21 CDT