Re: What is filling the logs

From: De DBA <dedba_at_tpg.com.au>
Date: Thu, 12 May 2016 17:30:10 +1000
Message-ID: <57343102.2010701_at_tpg.com.au>

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_at_tpg.com.au <mailto:dedba_at_tpg.com.au>> 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
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>
>
>
> --
> Niall Litchfield
> Oracle DBA
> http://www.orawin.info

--
http://www.freelists.org/webpage/oracle-l

Received on Thu May 12 2016 - 09:30:10 CEST