An Oracle checkpoint is an event that posts DMLs from the Redo log files to the tablespace files. Checkpoints always occur after a Redo log file switch and can also be configured to occur at predefined time intervals. For CA ERwin Data Modeler Workgroup Edition, which generates large transactions, checkpoints should occur only after log switches to minimize I/O.
To ensure a checkpoint only after a log switch, do not set the LOG_CHECKPOINT_INTERVAL and LOG_CHECKPOINT_TIMEOUT parameters in the INIT.ora or INIT<SID>.ora file.
|
Copyright © 2013 CA.
All rights reserved.
|
|