Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Regarding TRANSACTION RECOVERY

Regarding TRANSACTION RECOVERY

From: Giridhar <gkodakalla_at_gmail.com>
Date: 8 May 2006 22:34:05 -0700
Message-ID: <1147152845.214758.144960@j33g2000cwa.googlegroups.com>


Hi,
While reading backup and recovery manual, i read the following:



transaction recovery
Transaction recovery involves rolling back all uncommitted transactions of a failed instance. These are "in-progress" transactions that did not commit and that Oracle needs to roll back. It is possible for uncommitted transactions to get saved to disk. In this case, Oracle uses undo data to reverse the effects of any changes that were written to the datafiles but not yet committed

Can someone please explain how can uncommited transactions gets saved to disk.
I assumed only commited data gets saved to disk.

Thanks.
Giridhar Kodakalla. Received on Tue May 09 2006 - 00:34:05 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US