Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Log Switching interval
... 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
> >
> >
> >
>
>
Received on Fri Oct 08 1999 - 03:45:28 CDT