Re: Raw Partitions and Oracle

In the case where unix files are used, Oracle uses 'sync write' to ensure that the writes are written from FS buffer cache to the disk before returning. Not doing so would be real bad the health the database (imagine your redo entries are not written all the way out to online redo logs)

Pei

Declan O'Reilly <declan_at_mcs.com> wrote in article <3501D76A.D129C1FE_at_mcs.com>...
> In the oracle manuals they say that raw partitions are quicker than
> using files system for tablespaces etc. because it bypass's the overhead
> of the file system. But I thought that because unix file systems (we
> are using HP 9000 - 570 using 10.20) buffer data before it writes it to
> disk, that using a file system would be quicker since the database
> server would not have to wait for disk access.
> I thought that the reason for using raw partitions was more for data
> integrity i.e. the database server would not loose data if the machine
> crashes and the data is still in the buffer and not yet written to disk.
> I am missing something
>
> Declan O'Reilly
>
>
Received on Sun Mar 08 1998 - 00:00:00 CST