| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: Log Switching interval
Fred Dinage wrote:
>
> Thanks for th reply. What we want to do is not switch unless anything has
> been written to the online log. The alert log just gives info after the
> switch.
> "Reiner Neumann" <reiner.neumann_at_messe.de> wrote in message
> news:7tkavh$7kh$1_at_mail.messe.de...
> > ... also , you have to build new redo-logs with different sizes,
> > until you find out the size which is good for a 3-minutes-log-switch.
> >
> >
> >
> > Reiner Neumann <reiner.neumann_at_messe.de> schrieb in im Newsbeitrag:
> > 7tkaaa$7ih$1_at_mail.messe.de...
> > > Easy! Just look into the alert-file , usually in your
> ../bdump-dírectory.
> > > Every log-switch is written down there.
> > >
> > > It looks like this :
> > > Thread 1 advanced to log sequence 160664
> > > Current log# 3 seq# 160664 mem# 0:
> > > /home2/oracle73/oradata/DB73/redoDB7303.log
> > >
> > > Current log# 3 seq# 160664 mem# 1: /home7/oracle73/redoDB7303_02.log
> > > Thread 1 advanced to log sequence 160665
> > > Current log# 1 seq# 160665 mem# 0:
> > > /home3/oracle73/oradata/DB73/redoDB7301.log
> > >
> > > Current log# 1 seq# 160665 mem# 1: /home7/oracle73/redoDB7301_02.log
> > > Thread 1 advanced to log sequence 160666
> > > Current log# 2 seq# 160666 mem# 0:
> > > /home1/oracle73/oradata/DB73/redoDB7302.log
> > >
> > > Current log# 2 seq# 160666 mem# 1: /home7/oracle73/redoDB7302_02.log
> > >
> > > Hth,
> > > Reiner
> > >
> > >
> > > Fred Dinage <robby_at_robby.freeserve.co.uk> schrieb in im Newsbeitrag:
> > > 7tk8s8$rur$1_at_pheidippides.axion.bt.co.uk...
> > > > Is there any way in Oracle to check how much has been written to the
> log
> > > > files. We want to switch the logs every 3 minutes for a hot standby
> > setup
> > > > and we are currently just issuing an "alter system switch logfile"
> > command
> > > > every 3 mins.Ideally we would only like to switch logs every 3 minutes
> > > when
> > > > something has actually been written to the logs. How could we check
> > this??
> > > >
> > > > Cheers
> > > >
> > > > Fred Dinage
> > > >
> > > >
> > > >
> > >
> > >
> >
> >
Check Johnathon's post...
You can also look at V$LOG_HISTORY to see when switches are occurring and maybe look at more more/smaller logfiles to increase the frequency or larger ones to decrease the frequency..
HTH
--
"Some days you're the pigeon, and some days you're the statue." Received on Fri Oct 08 1999 - 06:01:35 CDT
 |
 |