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 about rollback and redo

question about rollback and redo

From: Ryan Gaffuri <rgaffuri_at_cox.net>
Date: 19 Sep 2003 12:39:10 -0700
Message-ID: <1efdad5b.0309191139.5eab5f6d@posting.google.com>


Documentation isnt too clear on this(or Im just not following it).

When you do a delete the entire row is copied to the rollback segment. Now if Im deleting 1MB worth of data in the datafile(lets assume there is no pctfree or pct used, just data), will 1MB of data be written to rollback? Im assuming there will be less due to block header, etc..., but how much less?

Now when the rollback is written to redo, how much data does that entail? What goes in a 'change vector'? Does the entire row get copied twice? Once to the rollback and once to the redo logs? Received on Fri Sep 19 2003 - 14:39:10 CDT

Original text of this message

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