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 -> Re: A Theoretical Situation

Re: A Theoretical Situation

From: Scott Thompson <sft_at_lucent.com>
Date: 1997/08/01
Message-ID: <33E25955.22FD269A@lucent.com>#1/1

Oracle will not 'wrap' onto an 'active', one containing open transactions,
redo log in archivelog mode.

--
Scott Thompson

Alan Gano wrote:


> Hi,
>
> Assuming an instance of this configuration:
> - 5 redo logs of 10K each.
>
> Assume this situation:
> - A single transaction (say an UPDATE) produces more than 50K of redo
> information, filling the redo logs, and then wraps around.
> - There is plenty of rollback space for the transaction.
> - The transaction is not committed.
>
> In this situation, some redo information concerning the transaction is
>
> being overwritten or written off to offline archive logs. I would
> assume
> that at least some of the modified blocks for this
> offlined/overwritten
> information has been getting written out to the datafiles by DBWR.
>
... lines deleted ...
Received on Fri Aug 01 1997 - 00:00:00 CDT

Original text of this message

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