Re: Should I use Raw devices?

From: Art S. Kagel <kagel_at_bloomberg.net>
Date: Tue, 25 Aug 1998 10:49:24 -0400
Message-ID: <35E2CEF4.54E9@bloomberg.net>

Ng K C Paul wrote:
>
> I wonder if raw device will improve the performance.

Yes, typically performance is 20-30% better with RAW devices than filesystem files and cooked devices being OSYNC'd. Performance is only about 5-10% better than filesystem without OSYNC and that is where the myth that RAW is not much better than COOKED comes from. However, no self respecting database server would risk running on COOKED disk without OSYNCing.

> Greg C. (gdclark_at_southwind.net) wrote:
> : Hi everyone. I am using Oracle8 and need your help. I am supporting a OLTP
> : DB being updated by a web application. At this point we do not know for
> : sure the volume of users who will be active at any given moment.
> :
> : I understand that using raw devices will improve the performance of my
[SNIP] Art S. Kagel Received on Tue Aug 25 1998 - 09:49:24 CDT