Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Commit -> write to data file immediately???

Commit -> write to data file immediately???

From: David <david_petit_at_yahoo.com>
Date: Thu, 29 Mar 2001 15:00:26 -0800
Message-ID: <3AC3BE8A.BE37EE6F@yahoo.com> 






Hi all,



     When user issues "commit", does Oracle writes all changed data (of
this user) to data file immediately? Or Oracle writes to data file only
when database buffer is full or during checkpoint? IF Oracle not writing
to data file immediately, and at that time, Oracle is crashed and log
files (all) are corrupted, how does Oracle to recover the "committed"
data?




Thanks,


David
Received on Thu Mar 29 2001 - 17:00:26 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US