RE: LGWR switching statistic
From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Thu, 25 Sep 2014 20:14:14 +0000
Message-ID: <CE70217733273F49A8A162EE074F64D901E116B2_at_exmbx05.thus.corp>
From: oracle-l-bounce_at_freelists.org [oracle-l-bounce_at_freelists.org] on behalf of Hameed, Amir [Amir.Hameed_at_xerox.com] Sent: 25 September 2014 17:24
To: oracle-l_at_freelists.org
Subject: LGWR switching statistic
Date: Thu, 25 Sep 2014 20:14:14 +0000
Message-ID: <CE70217733273F49A8A162EE074F64D901E116B2_at_exmbx05.thus.corp>
Depends on what you're really trying to find and which version you're on.
"background checkpoints started" might be what you need.
Regards
Jonathan Lewis
http://jonathanlewis.wordpress.com
_at_jloracle
From: oracle-l-bounce_at_freelists.org [oracle-l-bounce_at_freelists.org] on behalf of Hameed, Amir [Amir.Hameed_at_xerox.com] Sent: 25 September 2014 17:24
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
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Sep 25 2014 - 22:14:14 CEST