Archive Log Size

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 Received on Wed Jan 13 2021 - 17:10:34 CET