DB Disk Layout - advice welcome

Hi all,

I have an Sun ultra 450 ( 4-296Mhz processors ), 2Gb of RAM and 11 (4.2 actually 4.0Gb) disks. I just upgraded to Solaris 8 and Oracle 8.1.7.

I'm kind of new to this and would like to design this right, but I don't have any accumulated data from the old database. I also know that I should be reading about this, which I am, but alot of the design seems to depend on an analysis of an existing system. In any case I will continue to look at the manuals and hope you can point me in the right direction for now.

I have this layout proposed and would welcome any advise

Disk 0 (c0t0d0s0): OS - 2Gig

( s1): swap - 2Gig (to match RAM)

Disk 1	(c0t1d0s1): swap or ?? - 2Gig


	(      s4): Oracle - 2Gig


Disk 2	(c0t2d0):   System - 2Gig
		    redo_01 - 500M
		    control_01 - 500M
		    
Disk 3	(c2t0d0):   seems like a bad disk (partion map was overwritten
		    while writing to raw file during dbcreation)

Disk 4	(c2t2d0):   User - 2Gig
		    Indx - 500M	(I know we check index and then read)

Disk 5	(c3t0d0):   Temp - 2 Gig
		    redo_02 - 500M        

Disk 6	(c3t2d0):   Tools - 500M
		    control_02 - 500M
		    
Disk 7	(c4t0d0):   Drsys - 1G
		    redo_03 - 500M

Disk 8	(c4t2d0):   Rbs - 1.5G
		    control_03 - 500M

Disk 9	(c5t0d0):

Disk 10	(c5t2d0):

Some of the sizes are rediculously large, I know, but does making the partition that large harm the performance?? I doubt it myself.

When I run dbassist, I'm given default sizes for the files. Should I increase
these numbers to the size of the partion or just let the file grow by extents into the partition??

Can I just add a system_02 to the script, along with its redo files and have system consist of both??

Thanks for any advice and comments.
-Dirk Received on Thu Mar 01 2001 - 18:27:09 CST