Re: How to organize oracle directories in Unix ?

It isn't mount points that matter for I/O contention, it is spindles and channels - the physical disk layout. If this is one set of disks used in one large RAID-5 setup, then creating multiple mount points for logical volumes created on top of it will do nothing to reduce I/O contention. To balance out I/O, you MUST know the physical layout underneath the logical volumes and balance the I/O against that.

-Don Granaman
[certifiable OraSaurus]

• Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Sunday, September 09, 2001 9:55 AM

> Hi Joe,
>
> What's your configuration ? Raid 1 ?
> How do U organize the oracle directories ?
>
> Correct me if I am wrong. I thought though I use Raid 5 but with different
> mount points, I will not have contention problems
> For example
> One mount point for data files
> Another mount point for index files.
>
> Please advise. Thanks.
>
> Regds,
> New Bee
> -----Original Message-----
> To: Multiple recipients of list ORACLE-L
> Sent: 09/09/2001 8:30 PM
>
> if u dont know the underlying striping and someone else built the
> filesystes, then the point is moot, you might as well have one logical
> disk, since you cant reallt guarantee where something is going to end up
> anyways.
>
> with all of the raid5 stuff(that evryone likes so much anymore), we as
> DBAs dont have control over where stuff is, so a good backup/recovery
> plan is a must, at least in the old days when a physical device was
> mapped to a filesystem(pre-logical volume days), we could handle making
> sure of duplexing redo logs, etc.
>
> joe
> "CHAN Chor Ling Catherine (CSC)" wrote:
> >
> > Hi Guru,
> >
> > How do you organize your oracle directories in Unix ?
> >
> > I am thinking of using the configurations below. We are using Raid 5
> with
> > various mount points.
> >
> > \dg1\oracle => contains Oracle Human Resources software applications
> and
> > oracle home .eg. sidappl, sidcomn, sidora
> >
> > \dg2\oracle => contains redo log file and control file eg. sidredo &
> sidctrl
> >
> > \dg3\oracle => contains redo log file and control file eg. sidredo &
> sidctrl
> >
> > \dg4\oracle => contains redo log file and control file eg. sidredo &
> sidctrl
> >
> > \dg5\oracle => system tablespace file and temp tablespace data file
> .eg.
> > siddata
> > \dg6\oracle => data file and rollback segment data file .eg. siddata
> > \dg7\oracle => index file eg. sididx
> > \dg8\oracle => archive log file .eg. sidarc
> >
> > Is there any disadvantage if I put the redo log file and control file
> in
> > different directories but in the same mount point ?
> >
> > Is there any disadvantage if I put the rollback segment data file
> together
> > with my data file in the same directory ?
> >
> > Is there any disadvantage if I put the tablespace data file together
> with my
> > temp tablespace data file in the same directory ?
> >
> > TIA
> >
> > Regds,
> > New Bee
>
> --
> Joe Testa
> Performing Remote DBA Services, need some backup DBA support?
> For Sale: Oracle-dba.com domain, its not going cheap but feel free to
> ask :)
> IM: n8xcthome or joen8xct
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Joe Testa
> INET: teci_at_the-testas.net
>
> 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).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: CHAN Chor Ling Catherine (CSC)
> INET: clchan_at_nie.edu.sg
>
> 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).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Don Granaman
  INET: granaman_at_home.com

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).