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

"DA Morgan" <damorgan_at_x.washington.edu> wrote in message news:1114627327.78052_at_yasure...
>> 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.
> --

Just tried 10g as well - there seem to be some nasty little bugs in the software. For example, on bouncing the database with sessions = 300, and getting two sessions to run a loop that did:

    insert a new longops row
    sleep 0.01 seconds
for 530 cycles, I got:

Bounce:
Test 1: One process got 250 rows in, the other got none Bounce
Test 2: Both processes got 250 plus a few rows in Bounce
Test 3: The total number of rows inserted was 250.

Then, when I disconnected the sessions, v$session_longops went empty - and refused to accept any more rows.

10.1.0.4 - Windows XP Pro

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