Ramin Hossaini's Blog

22May/10

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.
Page 1 of 11
Bear