Re: Raw Disk Partition vs. Unix File System (Oracle 6)

In article <CC7IoC.FtA_at_vistachrome.com> andy_at_vistachrome.com writes:
>cafe_at_cbnewse.cb.att.com (richard.dib) writes:
>>- Does anybody have any experience with Oracle using a raw disk partitition
>> instead of the Unix file system? Could you share your experiences?
>
>I have experience only with Unix fs-based database files. Some of our
>australian friends believe highly in raw file systems. Some have seen
>as much as 25% improvement in speed over cooked file systems, and sometimes
>as much as 50% when used over a fragmented cooked file system.

            ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

I find that if my car is dirty and has a flat tire, then fixing the flat and washing it makes it go 95% faster. Does this mean that going to the car wash improves by road performance by 95%? :-}

Of course your going to get a huge increase going raw over a fragmented cooked file system. The question though is how much of that is the result of going raw vs unfragmenting the datafiles.

Could it be that the vast majority of perf increase was do to the compression of the extents and that they could have gotten most of that increase by just rebuilding the File System and database?

-- 
Regards, 

Lee E. Parsons                  		Baker Hughes Inteq, Inc
Oracle Database Administrator 			lparsons_at_exlog.com