On 04/19/2004 05:28:27 PM, Ryan wrote: > Now my book says the optimal way to do this is to check for all open > transactions at the time of the last checkpoint that have committed after > that checkpoint. > > Anyone know more? In particularly know 'why'? It's elementary, my dear Ryan. Oracle has first to recover transactions to roll them back. If the changes recorded in the undo blocks are not applied to the database, how do you propose to roll them back? -- Mladen Gogala Oracle DBA ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------