Re: Advantage of Raw Device-based database over Filesystem-based Database (Is there any?)

On Thu, 03 Sep 1998 11:09:20 -0700, giau45_at_yahoo.com <giau45_at_yahoo.com> wrote:
>What do you need to setup first before choosing raw devices.
>Any sort of special disk drive ? How do you measure the 20-30%
>performance difference ? Thanks.
>
>Deborah Csongradi wrote:
>
>> We have been using raw devices on SCO UNIX for 4 years
>> and have had no problems. We compared cooked to raw
>> and the performance increase was in the neighborhood
>> of 20-30% using raw....which is very significant.
>>
>> giau45_at_yahoo.com wrote in message <35EC87C3.48EA7898_at_yahoo.com>...
>> >Is there any advantage of Raw Device-Based Database over
>> >Filesystem-Based Database ?
>> >
>> >In what case, one prefers Raw Device-Based database over
>> >Filesystem-Based database ?

Note that the performance variance varies with filesystem (which can vary with vendor). The general consensus is the performance increase is much less than 20-30% with a modern unix and a complicated real world system. YMMV. The only way to tell is to test both ways, properly. To test properly is very time and resource intensive. Of course, some configurations require raw.

See Oracle technical bulletins for a very good description of the issues.

1. Prob# 1011656.6 MAKING THE DECISION TO USE UNIX RAW DEVICES
2. Soln# 2059702.6 MAKING THE DECISION TO USE UNIX RAW DEVICES

http://support.oracle.com/cgi-bin/cr/getfile_cr.cgi?21860

>> >
>> >Thanks
>> >
>
>
>

jg
--
These opinions are my own and not necessarily those of Information Quest or Pebble In The Sky http://www.informationquest.com mailto:jgarry@nospameiq.com http://ourworld.compuserve.com/homepages/joel_garry Remove nospam to reply. mailto:joel_garry_at_compuserve.nospam.com "See your DBA?" I AM the @#%*& DBA! Received on Thu Sep 03 1998 - 15:39:41 CDT