Re: Two Drive Oracle Installation?

In article <30D08577.7FB8_at_venice.sedd.trw.com>

           lih_at_venice.sedd.trw.com "Matthew M. Lih" writes:
: I started this thread a while ago, but I haven't seen an answer. I only have
: two drives *total*, which includes the system disk. I can't get another disk.
: Where should I put my files?

How about:

	Two control files, one on each disc
	Make Oracle mirror your log files, i.e. one copy on each disc
	One rollback tablespace on each disc
	A Single temporary tablespace, in about 10 files, 5 per disc
	
	Share your heaviest use tables between the discs.
		(keeping each table on a single disc)

	For each heavy use table, share its indexes between the discs
		(i.e. if table T1 has 4 indexes, put 2 per disc)

	Put each really heavily used object into its own tablespace/file
	so that you can move single objects easily back and forth between
	the two discs simply by moving a single file.

This probably gets you the least worst trade-off between performance, resilience, and flexibility.

-- 
Jonathan Lewis