Re: Raw Devices

And there's always the possibility that your machine has 64 Gb of RAM of which Oracle can only use 1.7 Gb !

The filesystem buffer could then be the best place to use (a lot of) the rest.

--

Jonathan Lewis
Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk

Andrew Gilkes wrote in message ...
>Be careful about assertions that raw devices give better performance than
>cooked ones as this is not always the case. Take a look at what your
>application is doing, if it does lots of full table scans, using raw
devices
>may actually reduce overall performance, because you lose the benefit of
the
>Disk buffer cache.
>
>Tom Baker <tcbaker_at_erols.com> wrote in message
>news:7oqi1o$pni$1_at_autumn.news.rcn.net...
>> Hi:
>>
>> I am an ex Sybase DBA and new to Oracle. In Sybase you use raw devices
>for
>> performance and safety of your data from server failures.
>>
>> I have read that Oracle is betten on cooked files. Is this true? Any
>> suggestions?
>>
>> Thanks in advance.
>>
>> Tom
>> tcbaker_at_erols.com
>>
>>
>
>
Received on Thu Aug 12 1999 - 14:14:10 CDT