Hello Tom,

Looking at a flashback version query, it is obvious that all changes to a row are kept in the undo, not just the latest one.

My understanding is that the address of the undo corresponding to a specific row is stored in the header of the data block.

So my question is: do we keep a list of addresses to all the undo corresponding to a specific row in the header, or does Oracle perform a scan through all the undo segment to find all the corresponding undo data for the Flashback version query?

Thanks in advance
Carlos

PS: I do have you book, but after reading it, I still have this doubt.