Path: utzoo!utgpu!utstat!jarvis.csri.toronto.edu!mailrus!tut.cis.ohio-state.edu!ucbvax!agate!helios.ee.lbl.gov!pasteur!ames!pacbell!rtech!billc@rtech.UUCP From: billc@rtech.UUCP (Bill Coffin) Newsgroups: comp.databases Subject: Re: Corrupted database in Oracle Message-ID: <2718@rtech.rtech.com> Date: 13 Mar 89 01:36:01 GMT Sender: news@rtech.rtech.com Lines: 18 >From article <531@maxim.ERBE.SE>, by prc@maxim.ERBE.SE (Robert Claeson): > .... Under System V, Release 3.1 at least, there's a SYNC flag > for open() and fcntl() that sets synchronous write. But that's only sysV. BSD, I believe, still doesn't have this. Another good reason to use raw disk access: You can be clever about physically clustering pages. This can produce substantial performance improvements, since you can suck in an index or sequentially scan a table much faster than on vanilla UNIX, where pages can be scattered around any old place on the disk, causing longer seek times. (Britton-Lee got a lot of mileage out of this ability). You can also customize buffering to be more appropriate for your needs. billc@rtech.uucp ( or, if you must, {sun,pyramid,mtxinu,amdahl}!rtech!billc ) <> <> <>