Question: when ckpt occurs in oracle?
Answer: Checkpoint process (CKPT) Every 3 seconds the Checkpoint process determines the earliest redo log entry for which changes have not been written to the database. This becomes the checkpoint, and it is recorded in the control file and in all the datafiles.