Name
LOG_CHECKPOINT_INTERVAL
Synopsis
Value: 0-unlimited
Default: operating system dependent
Dynamic: ALTER SYSTEM.
Specifies the frequency of checkpoints in terms of the number of redo log file operating system blocks that are written between consecutive checkpoints. If the value exceeds the actual redo log file size, checkpoints occur only when switching logs. If the intervals are so close together that the checkpoint requests are arriving faster than the rate at which the server can satisfy them, Oracle may ignore some of these requests to avoid excessive checkpointing activity.
Get Oracle in a Nutshell now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
