Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Question on REDO & SCN

Question on REDO & SCN

From: Pradeep <agarwalp_at_eeism.com>
Date: 24 Nov 2005 06:52:45 -0800
Message-ID: <1132843965.534875.93730@g47g2000cwa.googlegroups.com>


I am presently reading Expert one-on-one oracle, but have a few questions:

  1. After a DML statement all the required redo is generated. But if i commit there is a small amount of redo generated. What is this redo ? (i think that this redo is is generated after the undo is updated with the SCN on COMMIT)
  2. delay block cleanout happens by getting the status of the transaction from the UNDO. In case the undo is overwritten, then it gives an error. My questions is why does it not take the SCN for that transaction from the redo (if not avaible in undo) and do block cleanout?

Thanks

Pradeep Received on Thu Nov 24 2005 - 08:52:45 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US