-
Hi All,
I was wondering how often should I have a log switch/checkpoint to occur and also how can I prolong the time between the log switches if I have to do so.
Bond.
-
This depends on two factores mainly:
1) Do u see checkpoint not complete in alert files, that means checkpoint is happening very fast , increase the size of redo log files .
If you see in v$sysstat, that background checkpoints completed do not match with background checkpoints started, tune your DBWR.
2) How often you want checkpoint to occur, how large is your redo log file, how large is your db_block_buffers, depending on that you can tune your checkpoint.
-
Hi,
You can set this with two parameters one is 1.LOG_CHECKPOINT_INTERVAL and 2.LOG_CHECKPOINT_TIMEOUT.
Second one works depending on the number of seconds that u set to checkpoint to occur,u set this in the parameter file.
First one specifies that many number of filled OS blocks to be written to the database
-
Hi,
I would like to point it out that as per Oracle Documentation The check point value should be such that it is larger than the largest redo log file. This is due to the fact that occuring of checkpoint will cause some performance problems. Frequent checkpoints reduce the performance of the database. So u should have the checkpoint interval as stated above.
Karthi
-
Thanks for your replies,
Is there a time range that the logfiles should switch as recorded in the alert.log file. At the moment my database instance is switching logfiles every 3 minutes. Is that too frequent?
Thanks,
Bond.
-
Hi,
What is the size of the redo log and how many groups you have? Based on that we can suggest the new sizes.
Besides this, are you having "Checkpoint not complete" message in alert log?
Baliga
-
Hey There,
The size of my redo log is 1M and I have three groups of log files. I have seen that message "Checkpoint not complete" before in my alert log.
Thanks,
Bond.
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
|