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

Daniel Morgan <damorgan_at_exxesolutions.com> wrote in message news:<3ECCD52B.21BF3FC3_at_exxesolutions.com>...
> 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.

Well written OCI code <> Well written PL/SQL code.

jg

--
@home.com is bogus.
Of course, well written OCI code might be an oxymoron! :-)
The same might be said of PL/SQL in some quarters...