Re: Need setup advice, 8i on Sun E250 with 3 drives

IMO, 3 disks is simply insufficient, you'll need at least 4. The problem with the current setup is disk 2 is going to be hit very hard, and will develop into a bottleneck.
I would recommend moving the archivelog files to either disk 3 or better still to disk 1.
The temporary tablespace should also be moved. IMO, you also need a separate tablespace for rollback segments. I would break down tablespaces by application not by user. The advantage of this is when you have problems with a tablespace only one application is affected.

Hth,

Sybrand Bakker, Oracle DBA

"root" <root_at_orbmedia.com> wrote in message news:395500c4.484613265_at_news.supernews.com...
> I am interested in getting opinions on how to setup as close to an OFA
> compliant Oracle 8i system with only 3 drives. Details below:
>
> * Sun E250.
> * 3 SCSI drives
> * Oracle 8i
> * Solaris 7
>
> I was thinking of using the drives like this:
>
> Drive 1: Solaris system software, ORACLE_HOME and other non-Oracle
> software.
> Drive 2: SYSTEM tablespaces, TEMPORARY tablespace, user INDEX
> tablespaces, archive logs and REDO logs.
> Drive 3: user DATA tablespaces.
>
> If you have another opinion of how to distribute Oracle amongst the
> spindles, I'd like to hear. Also, was planning to use filesystem
> rather than raw partition for ease of maintenance.
>
> I would also like to hear about opinions/techniques for creation of
> user tablespaces and index tablespaces on 3 drives and if it makes
> sense to create tablespaces for each user or an application or if it
> is common to hold many applications on one tablespace.
>
> TIA!
> root
>
Received on Sun Jun 25 2000 - 00:00:00 CDT