Re: Log Switching interval

From: Reiner Neumann <reiner.neumann_at_messe.de>
Date: Fri, 8 Oct 1999 10:34:09 +0200
Message-ID: <7tkaaa$7ih$1@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:34:09 CDT