Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> question about rollback and redo
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