Re: Archive Log Size

This might be highly relevant:

https://www.red-gate.com/simple-talk/sql/oracle/are-your-oracle-archived-log-files-much-too-small/

Regards
Jonathan Lewis

On Wed, 13 Jan 2021 at 16:11, Martin Klier - Performing Databases GmbH < martin.klier_at_performing-db.com> wrote:

> Hi folks,
>
> I observe a behaviour I can't explain:
>
> Platform: Windows
> Oracle Version: 12.1.0.2
> Online Redo Log Size: initially 300MB, later 1GB
>
> Sometimes the archived redo logs get as big as the redo log size is, but
> that's rarely the case. Usually, I end up with less than 100MB. Why?
>
> Whenever I hit ARCHIVE_LAG_TARGET, it's easy to explain, why they are
> smaller. Same during backups or when I switch manually. But why during
> normal operations, even high redo log pressure (log switch every 30sec),
> IMO the redo logs (and thus, the archives) should be pretty full, isn't it?
>
> The ratio is about 100MB for 300GB Redo Logs, and about 800MB for 1GB Redo
> Log size.
>
> Any ideas?
>
> Thanks a lot
> Martin
>
> --
> Martin Klier // Performing Databases GmbH
> Managing Partner // Senior DB Consultant
> Oracle ACE Director
>
> martin.klier_at_performing-db.com // https://www.performing-databases.com
>
>
>

--
http://www.freelists.org/webpage/oracle-l