Re: Raw Devices: Increased Performance?

Jo Manna wrote:
>
> Steve Long wrote:
> >
> > Jo,
> >
> > I strongly recommend you DO NOT use raw devices. Although you will see
> > a minimal performance gain ( < 10%), you will create a significant
> > increase in administrative overhead managing back-up and recovery as
> > well as considerably more time performing a recovery in the event of a
> > device failure. Economically speaking, it is cheaper to buy more
> > memory and processors to gain considerably more performance than to
> > spend the additional time on administrative tasks (personnel time) when
> > raw devices are used for minimal performance gains.
> >
> > Steve
> > 804-262-6332
> >
> > -----------------------------------------------------------------
>
> Steve,
>
> Thanks for the reply. This is quite interesting. I have previously
> used Sybase and I remember that using Unix File Systems instead of
> Raw Devices was not recommended. Just off the top of me head the
> reasons for this was something like...
>
> ... the Sybase Server being in 'charge' of the actual I/O and if using a
> Unix File System could not guarantee that a 'commit was a commit',
> due to the OS buffering..... and so on.
>
> Obviously we are talking about Oracle here and not Sybase, but I am
> just wondering how Oracle gets around this if at all, or have I missed
> something?
>
> Thanks
> Jo

 Sometimes I used raw devices for temp tablespaces. Received on Sun Jul 07 1996 - 00:00:00 CEST