G
gus
Guest
logical undo does not read the entire bi file. it only has to go back to wherever the transaction begin note is for the oldest active transaction. it does not have to look at notes from committed transactions. unfortunately, at the moment, there is no way to get an estimate of how much is left. if we numbered the notes from 1 to n for each transaction, then we could know how many notes were left to process. but we don't have that info. also, logical backout has "jump" notes that it uses to skip over stuff and there was a bug that got fixed recently where that was not working right. sorry but i don't remember what version that bug appeared in or what verions it was removed in. unlikely that the physical undo read 95 gb. and if it did, there would not be much left for the logical undo to process. the undo phase switches from physical to logical when it needs to. it does not start over when it switches, but keeps going from where it was when the switch took place.
Continue reading...
Continue reading...