Re: Databse File layout on only 4 drives Ideas?

I would argue that one drive should be dedicated to archive desitination - don't want to be sharing that if we lose a disk.

I am quite curious as to why a couple of you have written off the idea of splitting data and index across drives. This is a practise that I have followed for a while and I am wondering why it is being written off so quickly

"steve deno" <sldcrew2k_at_yahoo.com> wrote in message news:8e6b14d8.0301241033.32ee27ab_at_posting.google.com...
> Hello, I need to build an Oracle 9.2 database(non-production) on
> Solaris 9. The machine has just 4 physical drives. I have the
> following tablespaces to move on to this machine: SYSTEM, UNDO, TEMP,
> DATA, INDEX and TOOLS. I Have taken the approach of starting with
> splitting DATA, INDEX, UNDO, and SYSTEM on to different drives which
> leaves me with TOOLS and TEMP. I was planning on putting TOOLS on the
> same disk as system, which would leave me with
>
> DISK1 SYSTEM, TOOLS
>
> DISK2 UNDO
>
> DISK3 DATA
>
> DISK4 INDEX
>
> So, My questions are: Where should I locate TEMP, and where should
> my ARCHIVE directory be? Also, What glaring omissions do I have?
>
> I realize that this is not an optimal setup, but any ideas that you
> have would be GREATLY appreciated!
>
> Thanks
Received on Fri Jan 24 2003 - 23:26:43 CST