Re: Frequency of log switches

Kurt-Erich Finger wrote:
>
> 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

Take a look at v$sesstat joined to v$statname, and you get how much redo each session is generating

hth
connor Received on Thu Oct 09 2003 - 05:37:40 CDT