Re: File Separation

Hi,
I have also a database server with RAID disks in sets of RAID1,RAID5.
If you have 3 RAID1 sets I suggest that you should prefer to organize files acc. to their certain characteristics. Because logs are sequentially written files putting them with index tablespaces may slow down LGWR. You prefer to distinguish tablespaces as highly accessed. and snchronously accessed ones but I did'nt understand why you put system tablespace and temporary tablespace in the same set. If I were you and I have no other disks other that these 3 RAID1 sets then I would do like this:

  1.set operating system, Oracle software,

        archive logs
  2.set all Oracle tablespaces
  3.set controlfile(1 is enough because it is mirrored),

        online logs

I don't think that puting data and index tablespaces in differen disks make so much difference in performanse because Oracle always read index segments before reading data segments.

I hope I could give you some idea but if your experiences are different than mine, yours are always better of course.

On Wed, 22 Nov 2000 04:20:42 -0800 Schoen Volker <v.schoen_at_inplan.de> wrote:
> Hi List,
>
> I have a new server with 3 RAID1 partions. I like to know if the following
> file seperation is OK.
>
> partition1 operating system, Oracle software, system
> tablespace, temporary tablespace, archive logs, controlfile1
> partition2 data tablespace, rollback, controlfile2
> partition3 index tablespace, online redo logs, controlfile3
>
> Any comments are welcome.
>
> TIA
> Volker Schön
> E-Mail: mailto:v.schoen_at_inplan.de
> http://www.inplan.de
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Schoen Volker
> INET: v.schoen_at_inplan.de
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Received on Fri Nov 24 2000 - 03:05:01 CST