G'day!
I think I'm going mad.. I have a database which is completely idle. No jobs, no
job engines, no users connecting, just background processes.
log_checkpoint_timeout and log_checkpoint_interval are left default.
Yet the 1GB logfiles switch every 7 minutes on average.
I must be overlooking the obvious.. What could cause this rediculous amount of
log switches? It is a copy of the production database. I am now suspecting that
whatever causes it may also happen on the (very busy) production itself. Any
thoughts welcome...
Cheers,
Tony
--
//www.freelists.org/webpage/oracle-l