Re: Oracle Stats
Date: Fri, 15 May 2009 12:03:51 -0700 (PDT)
What you posted doesn't report the time between redo log switches. Try this query and see what it reports:
SELECT ROUND(AVG(1440 * (b.first_time - a.first_time)), 0) "Log switch
time - minutes"
FROM v$loghist a, v$log b
WHERE b.sequence# = a.sequence# + 1
AND a.sequence# = (SELECT MAX(sequence#) FROM v$loghist) ORDER BY a.sequence#;
I'll bet it returns a value greater than 0.
David Fitzjarrell Received on Fri May 15 2009 - 14:03:51 CDT