RE: LGWR switching statistic
Date: Thu, 25 Sep 2014 16:36:58 +0000
Message-ID: <1AFD62082EEAF0448EF1815139687F1324C629BC_at_NC2PWEX504.us.ad.lfg.com>
I am not sure if there is a standard for how far it goes back (documentation probably states) but V$LOG_HISTORY can be used to calculate overall switches and frequency. Often I use this view to pinpoint times of the day that have frequent switching. Mine seems to go back pretty far in most cases several months.
Chris..
Chris Ruel * Oracle Database Administrator cruel_at_lfg.com<mailto:cruel_at_lfg.com> * Desk:317.759.2172 * Cell 317.523.8482
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Hameed, Amir
Sent: Thursday, September 25, 2014 12:25 PM
To: oracle-l_at_freelists.org
Subject: LGWR switching statistic
Hi,
Is there a database statistic available that can tell how many times LGWR switched redo log files?
Thanks,
Amir
Notice of Confidentiality: **This E-mail and any of its attachments may contain
Lincoln National Corporation proprietary information, which is privileged, confidential,
or subject to copyright belonging to the Lincoln National Corporation family of
companies. This E-mail is intended solely for the use of the individual or entity to
which it is addressed. If you are not the intended recipient of this E-mail, you are
hereby notified that any dissemination, distribution, copying, or action taken in
relation to the contents of and attachments to this E-mail is strictly prohibited
and may be unlawful. If you have received this E-mail in error, please notify the
sender immediately and permanently delete the original and any copy of this E-mail
and any printout. Thank You.**
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Sep 25 2014 - 18:36:58 CEST