Re: Oracle Raw Partitions

From: Pete Simpson <psimpson_at_oucsace.cs.ohiou.edu>
Date: Thu, 27 Aug 1998 15:12:46 GMT
Message-ID: <EyCsxA.Ay8@boss.cs.ohiou.edu>

Raw is great when you have lots of disk... like a RAID cabinet that does the cacheing for you. Backup is best done with Oracle utilities, not unix commands. Our RAID cabinet allows us to add disk, resize, move disks, etc. all while the database is UP. This, for us, is a MAJOR advantage of RAW v.s. filesystem.

Pete

G.Anbazhagan <anbu1_at_mbox3.singnet.com.sg> wrote:
> Hi ,
> There will be no performance improvement . There will be performance
> degradation. When you use raw partion ,Oracle writes to the device
> directly. If you use file system , it is beffered. The advantage is , when
> power fails , you are sure the data is in the disk. Raw partition only
> provides better recoverabilty.

> Backup is a real pain. You have to use dd ( dump ) . You cannot use file
> system level copying.

> Raw partition is not worth trying...

> regards
> anbu

> A. Gordon <aog_at_capgroup.com> wrote in article <35e46366.14946541_at_news>...

>> Has anyone had experience with Oracle raw partitions?  If so, I'd
>> appreciate any reactions to them.  In particular, I'd like to know:
>> 
>> 1.  Do they provide any performance gain over file systems?
>> 
>> 2.  Are they really harder to manage?  
>> 
>> I've read some literature already; however,
>> personal experiences would be greatly appreciated!
>> 

-- 
Peter J. Simpson |          psimpson_at_oucsace.cs.ohiou.edu

Have a hobie day!| Received on Thu Aug 27 1998 - 10:12:46 CDT