Re: Raw Devices: Increased Performance?

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 Received on Tue Jun 25 1996 - 00:00:00 CEST