Thats true..

I guess I have to be more clear.. Let me try again..

My redolog files are 5 mb each and there is no activity in the databse since morning. But everyhour a log switch is happening.

log_checkpoint_interval = 999999999
log_checkpoint_timeout = 0

With the above 2 params, how can I justify a log switch every one hour when no activity is going on in the DB..

And Tamil, if you get a chance can you also look closer into another question I posted about error-0131 Insufficient Privileges when trying to access db thru connect internal.

Thx