RE: LGWR switching statistic

  • From: Jonathan Lewis <jonathan@xxxxxxxxxxxxxxxxxx>
  • To: "Amir.Hameed@xxxxxxxxx" <Amir.Hameed@xxxxxxxxx>, "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
  • Date: Thu, 25 Sep 2014 20:14:14 +0000

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
@jloracle
________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx [oracle-l-bounce@xxxxxxxxxxxxx] on behalf 
of Hameed, Amir [Amir.Hameed@xxxxxxxxx]
Sent: 25 September 2014 17:24
To: oracle-l@xxxxxxxxxxxxx
Subject: LGWR switching statistic

Hi,
Is there a database statistic available that can tell how many times LGWR 
switched redo log files?

Thanks,
Amir

Other related posts: