Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Mail to Dusan Bolek
Hello Dusan,
Thank you for your answer to my post in comp.database.oracle.server.
Please may I ask you a few questions about Oracle file placement as you are a real Oracle GURU ?
If you have to build a new Oracle 8i server, what would be exactly the hardware specifications of your machine (number of disks, RAID 1, 5 or 10, ... ?) and what would be your file placement ?
You said that RAID 5 is not a good choice because of slow performance. Actually RAID 5 is slow for write access. Yet some people recommend it for database installation ...
I guess RAID 10 is better but more expensive.
Please give me some hints in a few words.
I would appreciate your help.
Many thanks.
Best Regards.
Sam
Dusan Bolek wrote:
> "Richard Armstrong" <richard.armstrong_at_juno.demon.co.uk> wrote in
message news:<995625917.24519.0.nnrp-07.9e9809ca_at_news.demon.co.uk>...
> > Doesn't the RAID array make your 36G disks look like one big disk?
You
> > could just put all of your data files on the RAID array. It might
be worth
> > duplicating the database control file on the RAID array and on the
9G disk.
> >
> > Good luck,
> >
> > Richard
> >
> > Samuel Tran <stran_at_immostreet.com> wrote in message
> > news:3B57E796.1B7EF47F_at_immostreet.com...
> > > Hello DBAs,
> > >
> > > I'm planning to install Oracle 8.1.7 on a Linux Debian Potato.
> > >
> > > I have a 9 GB disk and a set of RAID5 disks (4x36 GB).
> > >
> > > What could be the most appropriate Oracle file placement for this
disk
> > > layout ?
> > >
> > > Should I spread a tablespace on several datafile on several
partitions ?
> > >
> > > You may spread an Oracle datafile accross multiple locations.
However I
> > > heard that Oracle would fill up location 1 first, then on to 2,
and so
> > > forth, sequentialy. Is this true ?
> > >
> > > I would appreciate any help.
>
> Mr. Samuel is in bad situation. With this disk configuration is
> impossible to spread datafiles correctly. The number of the disks is
> too low. The lowest number for good file placement is 6. One disk for
> Oracle instalation, one for data, system tablespaces and last disk for
> index, RBS and TEMP tablespaces, of course everything should be
> mirrored for performance and safety. Maybe with 5 drives still can be
> placement effective, but ORA installation can't be mirrored, which
> enlarges probability of not available DB server.
> With four big disks, the only solution is to use RAID5, which is
> pretty stupid system for database performance. Another option is
> non-mirrored disks, which is of course insane, because of security.
> So maybe only choice is to use 9GB disk for system, ORA instalation
> and 3x36GB RAID5 filesystem for everything else, but performance will
> be rather slow.
> It is better to have more smaller drives than few bigger ones. Better
> than 4x36 is 8x18, but smaller (cheaper) Unix servers are short of HDD
> slots usually.
>
> --
> _________________________________________
>
> Dusan Bolek, Ing.
> Oracle team leader
Received on Fri Aug 24 2001 - 04:45:08 CDT