alter system checkpoint

checkpoint_clause

Specify CHECKPOINT
to explicitly force Oracle Database
to perform a checkpoint, ensuring that all changes made by committed
transactions are written to datafiles on disk


.
You can specify this
clause only when your instance has the database open. Oracle Database
does not return control to you until the checkpoint is complete.

 

GLOBAL 
In a Real Application Clusters
environment, this setting causes Oracle Database to perform a checkpoint
for all instances that have opened the database. This is the default.

 

LOCAL 
In a Real Application Clusters
environment, this setting causes Oracle Database to perform a checkpoint
only for the thread of redo log file groups for the instance from which
you issue the statement.