Manual checkpoint in Oracle Database

Manually run the checkpoint in Oracle Database

When the Checkpoint occurred, it moves all the dirty buffers to the disk files. Make the buffer cache and data files in a synchronized state. Oracle database ensures all modified buffers are written from the data buffer to disk files and modified the header of the datafiles and control files.

Manually checkpoint in Oracle Database as:


Automatic checkpoint occurred as:

Following causing automatic checkpoint:

1. Every 3 Seconds.
2. At time of log switch ( Alter system switch logfile)
3. Before begin backup
4. Tablespace offline.
5. fast_start_mttr_target parameter
6. Tablespace Drop

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.