Forum Post: RE: Loooong Logical Undo Phase Question

  • Thread starter Thread starter gus
  • Start date Start date
Status
Not open for further replies.
G

gus

Guest
assuming logical undo has to read the rest of the BI we're down to 261 minutes to read 80 Gb (4 901 816 blocks) possible but not likely. note also that during physical undo, (almost) every note gets processed (i.e. undone) but during logical undo only some notes need to be processed, even for the case where every bi block has to be read. so the logical undo phase can be faster then the physical but ymmv depending on the ration of active to committed transactions.

Continue reading...
 
Status
Not open for further replies.
Back
Top