Re: LGWR switching statistic
- From: "David Fitzjarrell" <dmarc-noreply@xxxxxxxxxxxxx> (Redacted sender "oratune@xxxxxxxxx" for DMARC)
- To: "Amir.Hameed@xxxxxxxxx" <Amir.Hameed@xxxxxxxxx>, "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 25 Sep 2014 14:13:36 -0700
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@xxxxxxxxx>
wrote:
Hi,
Is there a database statistic available that can tell how many times LGWR
switched redo log files?
Thanks,
Amir
Other related posts:
