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

"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.

-- 
Regards

Jonathan Lewis

http://www.jlcomp.demon.co.uk/faq/ind_faq.html
The Co-operative Oracle Users' FAQ

http://www.jlcomp.demon.co.uk/seminar.html
Public Appearances - schedule updated April 5th 2005