Shahid,
Given your limited number of disk drives there is not much room to be
creative with the I/O distribution. What you have got is appropriate in the
given environment.
However, I would consider putting duplexed redo logs on /u1 and /u5. Also
control file-3 on /u1. I would also consider moving System TS to /u1. And
moving Rollbacks to /u6.

HTH,

Regards,

- Kirti Deshpande
Verizon Information Services
http://www.superpages.com

> -----Original Message-----
> From: [Email Address Removed] [SMTP:[Email Address Removed] Sent: Saturday, June 30, 2001 1:06 AM
> To: LazyDBA.com Discussion
> Subject: Distribution I/O - urgent please
>
> What is the best distribution on a unix system for data files, index
> files,
> rollback tspace, system tablespace, temp tablespace, redo logs and
> archived
> logs. If there is a issue on space, which of the above segments can
> coexist
> on the same set of disks(array/controller) toghether with minimum
> contention.
> We have distributed the load as shown below based on the availability of
> disks we have.
> Can anyone suggest a better solution please:
>
> Mount Points(Raid) Usage
> =================================================
> /u1 (18GB-RAID 0+1) Oracle Application
> /u2 (36GB-RAID 0+1) Tables data
> /u3 (36GB-RAID 0+1) Index data
> /u4 (18GB-RAID 1) System , Rollback, Temp, Tools tablespaces
> /u5 (18GB-RAID 1) Online Redo Logs,control file-1,export
> dumpfile
> /u6 (18GB-RAID 1) Archived logs,control file-2, DBA/Batch
> scripts,udump, bdump, pfile]
>
> The problem is where we shall duplex(oracle side)the archive and online
> redo logs?????
> If we duplex these on /u2, .. /u4 we will be defeatign the purpose of
> putting random
> and seq files separatly. So how do we minimise the contenion and still
> have
> archived
> and redo logs members duplexed from oracle.
> Note that we can not re-structrue the mount points different way due to
> disks availability etc.
>
> Thanks
>
>
>
> --------
> Oracle documentation is here:
> http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
> To unsubscribe: send a blank email to oracledba-[Email Address Removed] To subscribe: send a blank email to oracledba-[Email Address Removed] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl
> Tell yer mates about http://www.farAwayJobs.com
> By using this list you agree to these
> terms:http://www.lazydba.com/legal.html
Oracle LazyDBA home page