Re: v$undostat question
Date: Wed, 13 Feb 2008 09:42:57 -0800 (PST)
Message-ID: <6aa35415-19c3-48a0-8a29-10e6ae4bb3c8@1g2000hsl.googlegroups.com>
On Feb 13, 10:00 am, Chuck <skilover_nos..._at_bluebottle.com> wrote:
> Oracle 9.2.0.8
>
> How is it possible for maxquerylen to go from 1 to 9000 in a single 10
> minute interval? Is this a bug? Can't find anything about it on
> metalink. TIA
>
> SELECT begin_time,
> end_time,
> maxquerylen
> FROM v$undostat
> WHERE begin_time BETWEEN
> to_date('10-FEB-08 19:19:19', 'dd-mon-yy hh24:mi:ss')
> AND
> to_date('10-FEB-08 19:29:19', 'dd-mon-yy hh24:mi:ss')
> ORDER BY begin_time;
>
> BEGIN_TIME END_TIME MAXQUERYLEN
> ------------------ ------------------ -----------
> 10-FEB-08 19:19:19 10-FEB-08 19:29:19 1
> 10-FEB-08 19:29:19 10-FEB-08 19:39:19 9387
>
> 2 rows selected
It might be a bug. I've seen a number of folks reporting this behavior
on various 9i
versions. Have not seen a specific bug related to this.
However, as you guessed, ideally you should see the query progression
in
maxquerylen and it should not therefore jump from 1 to 9387.
Anurag Received on Wed Feb 13 2008 - 11:42:57 CST