-
Checkpoint Interval
Hi,
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.
Many Thanks,
-
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|