That's the strange thing - v$session says nothing happens. I ran Tanel's
Snapper4 with 30sec intervals around the log switches, and that also shows not
much is happening. DBWR, LGWR and CKPT are pretty much the only processes that
write any amount of data, and then still no more than 25k per interval. Not
nearly enough to fill the logs. Other processes that are sometimes active are
SMCO and EMON slaves, but the latter only read and the former hardly write
anything either.
I'm stumped.
On 12/05/16 15:22, Niall Litchfield wrote:
What does (g)v$session show? AWR - you could take a ten minute snapshot..
On Thu, May 12, 2016 at 5:40 AM, De DBA <dedba@xxxxxxxxxx
<mailto:dedba@xxxxxxxxxx>> wrote:
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
--
Niall Litchfield
Oracle DBA
http://www.orawin.info