RE: LGWR switching statistic
- From: Jonathan Lewis <jonathan@xxxxxxxxxxxxxxxxxx>
- To: Dimensional DBA <dimensional.dba@xxxxxxxxxxx>, "Amir.Hameed@xxxxxxxxx" <Amir.Hameed@xxxxxxxxx>, "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 26 Sep 2014 08:17:49 +0000
Actually it's worse than that -
alter system checkpoint;
will increase the background count (even though it sounds as if that should be
a foreground rather than background - probably relates to RAC, though since
"checkpoint local" doesn't result in an increment of the stat)
Regards
Jonathan Lewis
http://jonathanlewis.wordpress.com
@jloracle
________________________________
From: Dimensional DBA [dimensional.dba@xxxxxxxxxxx]
Sent: 25 September 2014 23:02
To: Amir.Hameed@xxxxxxxxx; Jonathan Lewis; oracle-l@xxxxxxxxxxxxx
Subject: RE: LGWR switching statistic
The V$archived_log view is best for this type of calculation as other variables
can cause checkpoints when log switches are not happening.
Matthew Parker
Chief Technologist
425-891-7934 (cell)
Dimensional.dba@xxxxxxxxxxx<mailto:Dimensional.dba@xxxxxxxxxxx>
View Matthew Parker's profile on
LinkedIn<http://www.linkedin.com/pub/matthew-parker/6/51b/944/>
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Hameed, Amir
Sent: Thursday, September 25, 2014 1:25 PM
To: Jonathan Lewis; oracle-l@xxxxxxxxxxxxx
Subject: RE: LGWR switching statistic
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<mailto: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:
