Log switch occuring very frequently
Hi,
I am using 10.2.0.4. The problem i am facing is that the log switch is occuring frequently. The size of my redo logs are 100MB but my archive files are hardly 50 - 60 MB in size the archiver is not waiting for the logfile to complete. The parameters of log_checkpoint in my db are
log_checkpoint_timeout=0
log_checkpoint_interval=0
Any ideas?
I am using 10.2.0.4. The problem i am facing is that the log switch is occuring frequently. The size of my redo logs are 100MB but my archive files are hardly 50 - 60 MB in size the archiver is not waiting for the logfile to complete. The parameters of log_checkpoint in my db are
log_checkpoint_timeout=0
log_checkpoint_interval=0
Any ideas?
0