Re: Unix Filesystem vs Raw Partition

Paul Zola <pzola_at_us.oracle.com> wrote:
>
>The Oracle RDBMS uses one of these two system calls to guarantee that
>the data associated with a transaction has "hit the disk" by the time
>that the COMMIT returns.

Will the entire system be synced on each commit? I would have thought that this would have had performnce implications. I had always figured that all writes to the redo log would be backed by a O_SYNC and the entire DB would be synced at a checkpoint. This is the least amount of syncing I can see that still ensures integrity. A sync only at commit would still leave you at risk if uncommited data had been flushed out of the SGA and writes to the redo logs was still pending.

Any white papers on how this works? BTW, You should have answered this on Monday. I would have been too busy working then to bother you. :-}

-- 
Regards, 

Lee E. Parsons                  		
Systems Oracle DBA	 			lparsons_at_world.std.com