Home » RDBMS Server » Server Administration » why commit doesnt make dbwr to write in datafile?
why commit doesnt make dbwr to write in datafile? [message #423789] Mon, 28 September 2009 04:54 Go to next message
Messages: 4
Registered: September 2009
Junior Member
Hi All,

Im a newbie to Oracle database. I went through all the possible material on net to get into basic architecture of Oracle db.

But I hv a query- Can anyone please make my doubt clear?

When a DML transaction is done , say "update" statement is fired, then the changed value is written to database buffer.
And the current and changed values are written into redo log buffer.
When we commit the transaction, the redo buffer writes the changes to Redo log files, rt?
My questions are -

1. Why doesnt DBwr write immeditely to datafile once the transaction is committed? as anyways, these values wont be changed?

2. It shouldnt be no more required in Redo log as well once it's written in datafile.

can u Please answer this? I'm getting no way out for these queries.

Thanks a ton , in advance!

- Im_vnew
Re: why commit doesnt make dbwr to write in datafile? [message #423792 is a reply to message #423789] Mon, 28 September 2009 05:17 Go to previous message
Michel Cadot
Messages: 65143
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You surely missed this one: Database Concepts


[Updated on: Mon, 28 September 2009 05:18]

Report message to a moderator

Previous Topic: Session Identification
Next Topic: sql suspension
Goto Forum:

Current Time: Fri Aug 18 19:07:35 CDT 2017

Total time taken to generate the page: 0.15847 seconds