Re: DBMS Failure Issue

On Sat, 12 Nov 2005 06:51:49 -0800, Leigh Williams 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?

Transaction doesn't commit until the commit record is written to the disk. In case of instance failure all transactions which haven't committed are rolled back. The answer to your question is "maybe".

-- 
http://www.mgogala.com