LOGBUF_INTVL configuration parameter

Use the LOGBUF_INTVL configuration parameter to ensure the logical log buffer is flushed periodically when only buffered logging is used.

onconfig.std value
LOGBUF_INTVL 0
units
Seconds
values
The integer value of the parameter is the maximum number of seconds between logical log buffer flushes.

Default value: 0 – The feature is disabled by default. The time since the last logical log buffer flush will not be used as a criterion for flushing the buffer.

Minimum value = 1

Maximum value = 2147483647

takes effect
After you edit your onconfig file and restart the database server.

Usage

Setting this parameter will also positively affect latency in a replication environment when buffered logging is used. During relatively quiet periods on the primary, log records may be pushed to secondaries more frequently.


Copyright© 2019 HCL Technologies Limited