Re: What does maxquerylen in v$undostat really mean?

From: Howard J. Rogers <hjr_at_dizwell.com>
Date: Sun, 12 Dec 2004 12:10:30 +1100
Message-ID: <41bb9a81$0$5112$afc38c87@news.optusnet.com.au>

premmehrotra_at_hotmail.com wrote:
[snip]

> HJR:
>
> Thanks. Yes, I had read Oracle's 9.2 documentation before posting and
> as you said some of the columns are not documeneted. Also, there was so
> much difference in elapsed_time of v$sqlarea and maxquerylen, I wanted
> to clarify. I still don't think any of my queries really took 3-4 hours
> to complete as maxquerylen seems to indicate.
> Regards,
>

Well, "thinking" is not ideal for these sorts of discussions. Tests and test cases are what you need. I'll do some if I get the time.

Regards
HJR Received on Sat Dec 11 2004 - 19:10:30 CST