Re: LGWR switching statistic

From: David Fitzjarrell <oratune_at_yahoo.com>
Date: Thu, 25 Sep 2014 14:13:36 -0700
Message-ID: <1411679616.81835.YahooMailNeo_at_web124704.mail.ne1.yahoo.com>

Not in 11.2; since I haven't a 12c database to check I can't say if that's been added. It's a simple query to write, really:

select trunc(first_time,'DD') day, count(sequence#) FROM sys.V_$LOG_HISTORY
WHERE TRUNC(first_time) >= TRUNC(SYSDATE)-&num_days+1 GROUP BY TRUNC(first_time,'DD')
order by 1;

Gives you counts, by day. You can modify that to give hourly counts if you want them.  

David Fitzjarrell

Principal author, "Oracle Exadata Survival Guide"

On Thursday, September 25, 2014 2:25 PM, "Hameed, Amir" <Amir.Hameed_at_xerox.com> wrote:    

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-l

Received on Thu Sep 25 2014 - 23:13:36 CEST