multiple oracle sessions [message #216529] |
Mon, 29 January 2007 04:12  |
piet.heyn
Messages: 3 Registered: January 2007
|
Junior Member |
|
|
Hello,
As I don't know the right forum for my question I try the general forum first.
We deploy a SqlWindows application on Oracle 9i, via Citrix Presentation Server to about 20 users. Lately we have a lot of problems with users locking each other. The application has been running for years in a multi-user setting with no problems at all.
Everytime a user report a problem with a not responding application we see that this user (and others) have multiple sessions in Oracle. These multiple sessions seem to lock each other.
In SqlWindows all the acquired handles to Oracle are on the same connection, so we would expect there to be only 1 session per user.
Can anyone explain how these multiple sessions might come to existance?
Thanks in advance.
|
|
|
Re: multiple oracle sessions [message #217335 is a reply to message #216529] |
Thu, 01 February 2007 14:38  |
dan_thorman
Messages: 14 Registered: January 2007
|
Junior Member |
|
|
well, i'm no expert (far from it, in fact) but if i had to toss a guess out there it would be that the previous sessions of the given user are hanging (the session isn't terminating upon logging out) and then they are also acquiring a new session upon logging back in.
Just a guess...
|
|
|