What is filling the logs

  • From: De DBA <dedba@xxxxxxxxxx>
  • To: "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
  • Date: Thu, 12 May 2016 14:40:39 +1000

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


Other related posts: