Hello, everyone,
Would anyone out there like to share their thoughts on the best way to
lay out dbspaces? We have several databases, ranging from 50 mg to
200 gig in size, that we're migrating to a new platform. Our new
platform is a Sun E4500 with 8-400hz processors and 1.5 gig of RAM. We
have an A-1000 disk array with 18 gig drives (10,000 r.p.m.), and a
single controller. The storage array is set up with a hardware level
RAID-5 configuration. We're using Veritas to manage storage. The new
platform will be running IDS 9.2 with Solaris 2.7.
We're trying to decide how many dbspaces we should allocate. Should we
allocate at least one dbspace for each database, regardless of the
size? Should we allocate one dbspace to dump all of the little
databases into? Should we allocate multiple dbspaces for the large
databases? Are there any advantages to fragmenting dbspaces with a
RAID-5 configuration? Any suggestions for a good chunk naming
convention?
I'm very interested to hear your thoughts on this subject.
Regards,
Vickey Crouch