Ramin Hossaini (blog)

Oracle: Forcing a checkpoint

A checkpoint makes sure that all changes to the database (that are still in buffers) are written to the datafiles.

1
2
3

SQL> ALTER SYSTEM CHECKPOINT;
 
SYSTEM altered.

Related posts:

1. Oracle: Recovering a Tablespace
2. Oracle: Basic user-logon auditing
3. Backing up an Oracle database without RMAN
4. Listing key Oracle Database files
5. Oracle: List all database-links