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

From: DA Morgan <damorgan_at_x.washington.edu>
Date: Wed, 27 Apr 2005 21:06:39 -0700
Message-ID: <1114660961.359078@yasure>

Jonathan Lewis wrote:

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

10gR2 is still in Beta. ;-)

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

Received on Wed Apr 27 2005 - 23:06:39 CDT