Re: Oracle Stats

From: <art_at_unsu.com>
Date: Sun, 17 May 2009 14:08:48 -0700 (PDT)
Message-ID: <6158721b-3606-4408-852c-db1cb741dbb4_at_n8g2000vbb.googlegroups.com>



On May 15, 2:03 pm, ddf <orat..._at_msn.com> wrote:
> 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

Query returns this:

Log switch
time - minutes


                       25
Received on Sun May 17 2009 - 16:08:48 CDT

Original text of this message