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

From: Marco Mischke <m.mischke_at_gmx.net>
Date: 12 Jun 2006 23:17:51 -0700
Message-ID: <1150179471.001769.37910@f6g2000cwb.googlegroups.com>

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 Received on Tue Jun 13 2006 - 01:17:51 CDT

This message: [ Message body ]
Next message: Andreas Sheriff: "Re: 10gR2 RAC: Mirroring OCR and voting disks"
Previous message: Mih: "Re: SQL performance on index?"
In reply to: crajac66_at_gmail.com: "Why are archive logs only approx. 50% of the size of the redo logs?"
Next in thread: crajac66_at_gmail.com: "Re: Why are archive logs only approx. 50% of the size of the redo logs?"
Reply: crajac66_at_gmail.com: "Re: Why are archive logs only approx. 50% of the size of the redo logs?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

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