All About the Initialization Parameter ARCHIVE_LAG_TARGET and Related Issues
(Doc ID 2673217.1)
Last updated on APRIL 17, 2023
Applies to:Oracle Database - Enterprise Edition - Version 10.2.0.1 and later
Information in this document applies to any platform.
This Doc talks about ARCHIVE_LAG_TARGET parameter and related Issues
ARCHIVE_LAG_TARGET forces a log switch after the specified amount of time elapses.
If set to 0 , it disables the time-based thread advance feature; otherwise, the value represents the number of seconds.
The typical, or recommended value is 1800 (30 minutes). Extremely low values can result in frequent log switches, which could degrade performance; such values can also make the archiver process too busy to archive the continuously generated logs.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document
|Questions and Answers|
|1. How to Change this parameter ?|
|2. Guidelines for setting ARCHIVE_LAG_TARGET|
|3. Related Parameter|
|4. Common Issues related to ARCHIVE_LAG_TARGET|