RE: LGWR switching statistic
- From: "Hameed, Amir" <Amir.Hameed@xxxxxxxxx>
- To: Jonathan Lewis <jonathan@xxxxxxxxxxxxxxxxxx>, "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 25 Sep 2014 20:25:12 +0000
The DB version is 11.2.0.3. The real need is to find out LGWR switches on
hourly basis. I can pull this information from the archive log view as well but
I was curious to know if there was also a DB statistic available that can
provide similar information.
From: Jonathan Lewis [mailto:jonathan@xxxxxxxxxxxxxxxxxx]
Sent: Thursday, September 25, 2014 4:14 PM
To: Hameed, Amir; oracle-l@xxxxxxxxxxxxx
Subject: RE: LGWR switching statistic
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<mailto: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<mailto: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:
