2009/6/7 harshan eppuram <harshan.eppuram@xxxxxxxxx> > Dear NIzar, > > DBA decides whether or not to run ckpt process. If DBA want ckpt process to > be runing he/she needs to set CHECKPOINT_PROCESS to TRUE init.ora file. > Incase you are running instance with this parameter on then there is a point > in checking for that ckpt process. > > Hope I am clear. > > Regards, > Harshan > checkpoint_process enables another chkp process to help in the process of checkpoint, if you have a lot of datafiles, but at least one chkp is always running. When you may have an useful oracle/server without checkpointer? D.