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
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.


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© 2018 HCL Technologies Limited