Process for Rollback Segment. [message #50591] |
Fri, 22 March 2002 20:04 |
Girdhari Choudhary
Messages: 18 Registered: March 2002
|
Junior Member |
|
|
Which process writes the data in rollback segment.as far as i know every transaction is written in the rollback segment and this is written to the any data file.there must be any background process which writes this entries to the rollback segment.
|
|
|
Re: Process for Rollback Segment. [message #50592 is a reply to message #50591] |
Fri, 22 March 2002 23:45 |
kiran srirama
Messages: 14 Registered: March 2002
|
Junior Member |
|
|
Hi...
There is no background process which writes to Rollback segments. LGWR writes to Redolog files and
NOT to Rollback Segments. ROLLBACK segments hold the before-DML values where as the REDOLOG files hold the
After-DML values (at pre-commit).
Oracle assigns each transaction , to a Rollback segment. When DML occurs within this transaction, they write to rollback segments in a cyclical-manner.
Hope this clears your understanding.
Regards
Kiran Srirama
|
|
|