Unix Filesystem vs Raw Partition
From: Henry Kwok <wdm2_at_ix.netcom.com>
Date: 8 Oct 1994 04:52:27 GMT
Message-ID: <3758ib$qii_at_ixnews1.ix.netcom.com>
Date: 8 Oct 1994 04:52:27 GMT
Message-ID: <3758ib$qii_at_ixnews1.ix.netcom.com>
I sent some comments recently to Joel Garry thru email instead of posting it to the net. Anyway I was curious to see all the threads re filesystem vs raw partition only address the performance issue but not the data integrity issue. Using Unix filesystem the data may still be in buffer while the DBMS thinks they are already written to disk. If the system crashes before the data is written out from buffer to disk, there may be serious data integrity problem. I've been to Sybase class and they all recommend using raw partition instead of file system because of this problem, not because of the gain in performance. Does Oracle architecture some how avoid this problem ? Received on Sat Oct 08 1994 - 05:52:27 CET