Re: Oracle Stats

From: ddf <oratune_at_msn.com>
Date: Fri, 15 May 2009 12:03:51 -0700 (PDT)
Message-ID: <3ced92bb-48dd-408f-bbeb-db865008950d_at_t10g2000vbg.googlegroups.com>


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

Original text of this message