Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> What does maxquerylen in v$undostat really mean?

What does maxquerylen in v$undostat really mean?

From: <premmehrotra_at_hotmail.com>
Date: 10 Dec 2004 21:37:11 -0800
Message-ID: <1102743431.248099.117360@z14g2000cwz.googlegroups.com>


I am using Oracle9i on HP UNIX 11i. When I do

select max(maxquerylen) from v$undostat

I get a number 13748 which is in seconds which is between 3-4 hours.

When I look in v$sqlarea for the maximum elapsed_time taken by any query it is only:
798220317

which I assume is in micro seconds, i.e., 798 seconds.

I am puzzled what exactly does maxquerylen mean, does it mean time in seconds taken by a query (that does not seem to be the case) or is it maximum time taken by a transaction.

Thanks,

Prem Received on Fri Dec 10 2004 - 23:37:11 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US