| why commit doesnt make dbwr to write in datafile? [message #423789] |
Mon, 28 September 2009 04:54  |
im_vnew
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
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
