Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Question about Sun disk space configuration for large Oracle database
Greetings.
I am currently developing the physical disk space layout for a large Oracle
database (over 2 terabytes of disks), and I wish to solicit some opinions as
to how to make this work. My configuration calls for each Oracle tablespace
to be placed on separate RAID 0+1 arrays. Each RAID array would be
controlled
by its own RAID controller. There are 13 such arrays and the largest of
these
arrays needs to be at least 550 Gigs. The system administrator with whom I
am working on this project has reviewed Sun hardware specs and has come to
the conclusion that 13 RAID controllers is not do-able. Instead, he
recommends using fewer RAID controllers and allowing each one to control
multiple arrays. I am primarily concerned with reducing I/O contention for
the Oracle tablespace files and wonder if a single RAID controller can
handle
multiple requests for different arrays in parallel. There is another problem
in that, according to his analysis, each RAID 0+1 array can accomodate, at
most, 8 disks. Assuming 36 gig disks, this would mean that the largest size
of a single RAID 0+1 array would be 144 gigs (4x36), significantly less than
my 550 gig target. Below, you will see my proposed physical layout for each
partition and its use. My questions for the Sun/Oracle experts are as
follows...
My company's upper management does not have the time right now (due to a very tight product development schedule) to bring in Sun reps to get answers to these questions, so I greatly appreciate whatever assistance the USENET community can provide.
PROPOSED CONFIGURATION
Dir Size Usage Recommendation ---- ----- ------------------------- -----------------Received on Tue Aug 07 2001 - 19:18:10 CDT
/ 50 GB All system software Four(4) 36 GB dsks RAID 0+1
/u01 2 GB First Online Redo Logs Part of root (/)
/u02 2 GB System tablespace Two(2) 36 GB dsks RAID 0+1
/u03 6 GB Temporary tablespace Two(2) 36 GB dsks RAID 0+1
/u04 100 GB Archived redo & exports Six(6) 36 GB dsks RAID 0+1
/u05 2 GB Second Online Redo Logs Two(2) 36 GB dsks RAID 0+1
/u06 8 GB Rollback for Data 1 Two(2) 36 GB dsks RAID 0+1
/u07 8 GB Rollback segments Two(2) 36 GB dsks RAID 0+1
/u08 80 GB Indexes for Data 1 Six(6) 36 GB dsks RAID 0+1
/u09 550 GB Data 1 Thirty-two(32) 36 GB dsks RAID
0+1
/u10 12 GB Indexes for Data 2 Two(2) 36 GB dsks RAID 0+1
/u11 60 GB Data 2 Four(4) 36 GB dsks RAID 0+1
/u12 4 GB Indexes for Data 3 Two(2) 36 GB dsks RAID 0+1
/u13 8 GB Data 3 Two(2) 36 GB dsks RAID 0+1