RE: What is filling the logs

Run this query several times

SELECT s.sid, s.serial#, s.username, s.program, i.block_changes FROM v$session s, v$sess_io i
WHERE s.sid = i.sid ORDER BY 5 asc;

-----Mensaje original-----

De: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] En nombre de De DBA Enviado el: jueves, 12 de mayo de 2016 6:41 Para: oracle-l_at_freelists.org
Asunto: 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

--

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

--

http://www.freelists.org/webpage/oracle-l Received on Thu May 12 2016 - 10:25:41 CEST