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

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