Home Australia and New Zealand how things happen in a commit process to redo log files
Thread details
What we know about this thread
Original section Australia and New Zealand
Published 16 May 2008
Last activity 16 May 2008
Original author obakesan
Posts 2
Discussion status Public discussion
Total views 1,811
Views / 30 days 0
The navigation and discussion metadata provide context. Posts remain in their original chronological order.
Showing posts 1–2 of 2 Posts remain in their original chronological order.
Original post obakesan
Archived post
16 May 2008, 12:55 UTC
#1
Hi
as I understand things when a change occurs something writes the change from the database buffer cache to the redo log buffer. Then upon commit (I suppose its) LGWR copies these changes from the redo log buffer into the redo log files. But does it also write the rollback segment relevant to the transaction too?
If so, I'm not sure I see why it might be needed?
thanks
See Ya (when bandwidth gets better ;-)
Chris Eastwood Photographer, Programmer Motorcyclist and dingbat blog: http://cjeastwd.blogspot.com/
please remove undies for reply
16 May 2008, 14:59 UTC
#2
whoops
wrong place
sorry folks
See Ya (when bandwidth gets better ;-)
Chris Eastwood Photographer, Programmer Motorcyclist and dingbat blog: http://cjeastwd.blogspot.com/
please remove undies for reply
Active in the last 60 minutes
Active in this thread
0 users
·
0 guests
· 0 bots
· 0 total
No signed-in users are active right now.
No known search crawlers active right now.