Re: Databse File layout on only 4 drives Ideas?

From: Howard J. Rogers <howardjr2000_at_yahoo.com.au>
Date: Sat, 25 Jan 2003 09:17:56 +1100
Message-ID: <EPiY9.32398$jM5.82628@newsfeeds.bigpond.com>

steve deno wrote:
> 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

See enormous threads passim. There's no need to separate DATA and INDEX onto separate drives (not upfront, anyway). So stick TEMP on DISK4, and I'd also stick archives there, assuming that you aren't going to be continuously running humungously large sorts all the time.

Regards
HJR Received on Fri Jan 24 2003 - 16:17:56 CST