Re: Difference between Redo Log Buffer & Rollback Segment?

From: <nasof_at_hotmail.com>
Date: Wed, 12 Aug 1998 12:30:51 GMT
Message-ID: <6qs1ts$bkn$1@nnrp1.dejanews.com>

A rollback segment is your UNDO helper. It saves all your work upto the point that you commit. IF you wish to undo your work, you simply issue a rollback statement.

If you commit, the changes that you made to the database,then these changes are sent to the Redo Log Buffer (which is really a transaction log buffer.) It store up all the transactions that take place against the database. The reason the word "Redo" is used, is because you can use the Redo Log Buffer to "Re-Do" (or Re-apply) all those transactions to the database when you are restoring it.

Hope this helps,
-Frank

In article <35d0fce7.9444218_at_news.twsc.pouchen.com.tw>, violin.hsiao_at_mail.pouchen.com.tw (Violin) wrote:
> I'm a little confused about them.
> Could anyone tell me what the difference is between them?
> Thank you so much.... :)
> Please Cc to : violin.hsiao_at_mail.pouchen.com.tw
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Wed Aug 12 1998 - 07:30:51 CDT