Re: can datafile and logfiles be store on raw disk?
Date: 1995/05/04
Message-ID: <3oakb4$a5h_at_crcnis3.unl.edu>#1/1
mmyers_at_dallas.net (Matt Myers) writes:
:In article <D80t8E.HwM_at_crash.cts.com>, jimt_at_bluebird.com () says:
:>
:>Can datafiles and or logfiles be stored on raw disk? All the examples
:>I have seen only show them stored in file system.
:>
:Absolutely. It just takes a little more experience. If the database is
:laid out correctly, you should see a performance gain(Mileage may vary
:depending on actual use). In fact, if your using Oracle Parallel Server,
:you must use raw disks. One important consideration, is how you plan to
:backup and restore the database.
This is definitely true for datafiles, but I'm pretty sure you can NOT store logfiles (and archived log files) on a raw file system. If someone has actually done this, I'd be interested in knowing how it was done!
--- Michael Nolan, Sysop for the DBMS RoundTable on GEnie nolan_at_tssi.com, dbms_at_genie.com, nolan_at_inetnebr.com (posted from nolan_at_helios.unl.edu)Received on Thu May 04 1995 - 00:00:00 CEST