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: Why are archive logs only approx. 50% of the size of the redo logs?

Re: Why are archive logs only approx. 50% of the size of the redo logs?

From: <crajac66_at_gmail.com>
Date: 13 Jun 2006 07:12:15 -0700
Message-ID: <1150207935.544131.296620@y43g2000cwc.googlegroups.com>

Marco Mischke wrote:
> Hi,
>
> crajac66_at_gmail.com wrote:
> > Is there anything other than a manual log switch that would cause the
> > online logs to switch before they are full? I'm making the assumption
> > that the online logs are switching before they are full because they
> > are only half the size of the archived redo logs. Is this an accurate
> > assumption?
>
> Is ARCHIVE_LAG_TARGET set to a value greater than zero? That would
> force a log switch every X minutes.
>
> -Marco

Thanks for the suggestion but ARCHIVE_LAG_TARGET is set to 0

NAME                                 TYPE        VALUE
------------------------------------ -----------
------------------------------
archive_lag_target                   integer     0
Received on Tue Jun 13 2006 - 09:12:15 CDT

Original text of this message

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