How many times in an hour do you have redo log switch? If it less then 15 minutes you should make your redo logs bigger (in 9i by default they are 3 groups 100MB each, you can try with something simmilar).
Values are :
Also I have 4 groups with 1 member each. Log switching occurs almost after 15 mins. But its occur i think because of Materialized Views. There are no of MV which does complete refresh from other DB server after 15 mins. There are no high no users accessing database.
Is there any way to increase timing between archived files and thus reducing no of archives files generated.
Originally posted by stancho Julian if those 2 parameters are incorrect I think the sessions will wait for checkpoint ?
Yes, checkpoints will happen often and this will cause file header syncronization to take place often too. It may be a matter of moving his/her online logs to another disk. It could be that the current disks are too busy. This should be avoided.
And greetings from Bulgaria
Oracle Certified Master
Oracle Certified Professional 6i,8i,9i,10g,11g