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> 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