Frequency of log switches

From: Kurt-Erich Finger <kurt-erich.finger_at_hte-company.de>
Date: 8 Oct 2003 00:27:07 -0700
Message-ID: <5208be2f.0310072327.14f5c0d9@posting.google.com>

Oracle 8.1.7 on Linux 2.4

Hello,

I am trying to implement a back-up/recovery procedure in my company. To test it, I took a copy of the production database, added

log_checkpoint_interval = 10000
log_archive_dest=/data/arc
log_archive_format='arc%s.log'
log_archive_start=True

to the init-file and started the instance with ALTER DATABASE ARCHIVELOG The archived logs are generated, however, at a high frequency. Before I switched on archiving there were only some log switches per day. Switching on archivelog I got new logs (and archived logs) every minute when the the size of the log-files was 10mb and log switches every 20 minutes when the size of the log-files was 50mb. The frequencies seem to be very high taking into account that there is no (user) activity on the instance.

How can I reduce the log switches to reasonable numbers? (increasing log_checkpoint_interval did not help)

Cheers,
Kurt-Erich Received on Wed Oct 08 2003 - 02:27:07 CDT