Re: Which one is better 1 connection lots of open cursors - more connections less open cursors

Marc Eggenberger wrote:

> Hi there.
>
> I've been asked this question.
>
> A java programmer told me that the application at his company is using
> quite a few open cursors.
> At the moment about 300 per "Special-User".
> The normal User does not have that much. Dont know excatly, thats just
> what he told me.
> Now he asked which one would be faster. One connection with all the open
> cursors or multiple connections (like 10) and then having the cursors
> distributed over those connections.
>
> I would have said that the overhead of having multiple connections would
> be greater and I would use the first approach. But I'm not sure. What
> would you say?
>
> The app runs under Oracle 9R2 under Windows and Unix.
>
> Is there a signifikant difference? Or cant it be said because the
> application is not know?
>
> Thanks for any comments
>
> --
> mfg
> Marc Eggenberger

I would say two things:

1. It is probably irrelevant. There will be differences between the two but probably unmeasurable
2. Testing is worth more than speculating.

I'm still trying to figure out how any well written code has 300 simultaneously open cursors.

--
Daniel Morgan
http://www.outreach.washington.edu/extinfo/certprog/oad/oad_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)