Flashback vs. rollback mechanism

From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Fri, 23 Jan 2009 15:02:21 +0000 (UTC)
Message-ID: <glcm5s$8ht$1_at_solani.org>

In the newer versions of Oracle there are 2 distinct mechanisms for undoing the effect of transactions: rollback and flashback. Rollback method is transactional, it simply undoes the changes made to the blocks during the failed transaction while the flashback method is more akin to recovery. The differences between those two methods are numerous but the outcome will, in many cases be the same. Should we expect to see some blending between rollback and flashback? I believe that in the future releases the fine line between the rollback and flashback will be blurred, possibly by introducing "fast rollback" which will use recovery-like methods characteristic of the flashback but will be used within transaction as a "get me my old values back" mechanism.

This, of course, is just a mental experiment. Any thoughts?

Mladen Gogala
Received on Fri Jan 23 2009 - 09:02:21 CST

Original text of this message