Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: logfile switching frequency
"Jim Kennedy" <kennedy-family_at_home.com> wrote in message news:<5utK7.50803$XJ4.29681964_at_news1.sttln1.wa.home.com>...
> That depends. Think of the logfiles as recording all the transaction
> activity in the database. The higher volume of changes the more often they
> will get filled up and switch. If there were no transactions then they
> wouldn't switch.
> Jim
> "Tomasz Boboli" <tboboli_at_elka.pw.edu.pl> wrote in message
> news:9tdh0i$mr9$1_at_julia.coi.pw.edu.pl...
> > Hello,
> > My database has 4 logfiles.
> > How often Oracle should switch between those files?
> >
> > Thank you,
> > Tomek
> >
> >
If you look at the alert file during peak tranaction time and notice
that the alert file is switching more than one per minute, you want to
make the redo logs bigger. What you don't want to occur is the
database to pause on occasion until log switches occur. You will
notice the pause if logs switch constantly.
Received on Tue Nov 20 2001 - 13:34:01 CST