Re: DBMS Failure Issue

On 12 Nov 2005 06:51:49 -0800, "Leigh Williams" <leighwilliams_at_gmail.com> wrote:

>The logwriter writes to the logfile on disk, so it must accumulate a
>block of log records before flushing to the log file. Suppose a
>transaction commits, but the commit record flushing is delayed by the
>log writer waiting to fill a block. What would happen to the
>transaction if DBMS failure occured while waiting for its commit record
>to be flushed? Would it simply be a case of a transaction undo in
>recovery?

As the commit marker, ending the transaction is missing, and the before image is still present in the undo segments, the transaction will be undone.

--
Sybrand Bakker, Senior Oracle DBA