Re: Concepts question about Redo Log Files

From: Ian Sparkes <isparkes_at_analysts.com>
Date: 1997/01/06
Message-ID: <01bbfbf8$b291c760$1015f5cc@primenet>#1/1

Writing to redo logs is much faster than writing to database files.

To write data to a DB file Oracle has to locate the correct file location by interpreting the actual data and then worry about issues such as extents, chaining ...

To write to a redo log file all Oracle does is to append a steam of bytes to the end of a sequential file. There is little intelligence involved in the process so it is much faster.

Paul <bfekrat_at_erols.com> wrote in article <32CD9B41.6EB3_at_erols.com>...
> Could someone please explain to me the reason we must have redo log
> files? That is, why can't we just write committed transactions directly
> to the data files?
>
Received on Mon Jan 06 1997 - 00:00:00 CST