Re: Ref Cursors Resultsets and ADO

I am actually running into the same problem with a web application. Are you using the Merant driver and vb script?

iii
In article <965930006.4960.2.pluto.d4ee154e_at_news.demon.nl>, Sybrand Bakker <postbus_at_sybrandb.demon.nl> writes:
>
>"Keith Jamieson" <Keith.Jamieson_at_phoenix.ie> wrote in message
>news:8mtpfs$dbg$1_at_kermit.esat.net...
>> I currently have tested returning a resultset from ADO
>> (both 2.1 and 2.5) , using a stored procedure returning a Ref Cursor.
>>
>> After the procedure is called 50 times, an Oracel error is returned (Two
>> many open cursors).
>>
>> The max no of open cursors is set to 50 in my Database (probably the
>> Default).
>>
>> Presumably this is beacuse ADO does not close the cursor.
>> Is there anything I can do on the server side to overcome this limitation.
 I
>> sit possible to close a ref cursor if it is open.
>> What is the potential impact.
>> What is a sensible no of open cursors to have for a 350 user system
>>
>>
>> TIA
>
>50 is the default. Usually 500 is more sensible and you will most likely
>never run out of it. Please note open_cursors is a *per user* limit, so
>every user will get 500 cursors. Times 350 users can result in heavy memory
>consumption. You should really try to close that cursor.
>
>Next time, please abandon the excessive crosspost. This is a .server topic
>and shouldn't get posted to *all* Oracle newsgroups.
>
>Hth,
>Sybrand Bakker, Oracle DBA
>

• Posted via NewsOne.Net: Free (anonymous) Usenet News via the Web ----- http://newsone.net/ -- Free reading and anonymous posting to 60,000+ groups NewsOne.Net prohibits users from posting spam. If this or other posts made through NewsOne.Net violate posting guidelines, email abuse_at_newsone.net