How do i introduce checkpoint parameters in my databse? I am working on a oracle 9i database. Checkpoint starting as a background process after 8i( If i am wrong please correct me). If it is starting as a background process.... what parameters sould i set to get the good performance level.
"Frequent checkpoints will enable faster recovery, but can cause performance degradation"
Have anyone experienced performance degradation while using checkpoints.