archive_lag_target ?
cron with alter system switch logfile ?
Are you running in archivelog mode ? How much redo is actually generated
between switches ?
Can you find any SQL in v$sql with a large number of executions that might be
generating redo - e.g. from auditing a series of failed logins that never
produce sessions and therefore never appear in snapper output ?
Regards
Jonathan Lewis
http://jonathanlewis.wordpress.com
@jloracle
________________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx [oracle-l-bounce@xxxxxxxxxxxxx] on behalf
of De DBA [dedba@xxxxxxxxxx]
Sent: 12 May 2016 05:40
To: oracle-l@xxxxxxxxxxxxx
Subject: What is filling the logs
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
--
//www.freelists.org/webpage/oracle-l