Re: How much data can you put in v$session_longops

From: DA Morgan <damorgan_at_x.washington.edu>
Date: Wed, 27 Apr 2005 11:46:06 -0700
Message-ID: <1114627327.78052@yasure>

Jonathan Lewis wrote:

> "DA Morgan" <damorgan_at_x.washington.edu> wrote in message
> news:1114555661.744903_at_yasure...
>
>

>>8i is so long ago I can hardly spell it. With 9i ... v_$session_longops
>>supports OEM's progress bar and I have personally run a substantial
>>number of sessions simultaneously tarcked through OEM without any
>>indication there was a limit (which is not to say there isn't one).
>>

>
>
> Supporting a progess bar requires just one row in v$session_longops,
> so that proves nothing.
>
> Running a "substantial" number of sessions simultaneously (even if
> every one of them has its own progress bar) means virtually nothing
> if the limit is actually 2 x sessions. (Although I now realise that that
> expression is a little easy to mis-interpret: it means 2 x the sessions
> parameter, not 2 x the current number of sessions).
>
> I've just located and re-run my test case - The number of slots
> in v$session_longops for 9.2.0.6 seems to be the lower of
> 500 and 2 x the sessions parameter. If you try to create a new
> row when the limit has been reached, you get an index number
> of zero and a slot number of -1.

Thanks for the information. I will now try to remember it for future reference.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)

Received on Wed Apr 27 2005 - 13:46:06 CDT