March 10, 2009 at 5:16 am
I need your help!
When we go to Management / Current Activity / Process Info, we can identify users connected to the database. When running an application we will have multiple connections to the database. The more screens we open the more connections we will have. Also certain APPS have several open cursors within that will add to the connection list. The HOST name is the computer name and the LOGIN name are the users logged in to the system.
It is understandable when we have multiple connections to the database from a single workstation when running an application as it uses multiple connections to obtain the information from the server. However, is there a way to explain why some computers have more than one user associated with it without having more than one user log on from that workstation at different times?
For example, if USER1 logs into an application from WORKSTATION1, and for whatever reason their connection to the database isn't released, so when USER2 logs in from WORKSTATION1, you could see both USER1 and USER2 for WORKSTATION1. But I can't explain how USER1 and USER2 could be associated with WORKSTATION1 if USER2 had never logged in from WORKSTATION1. Is this possible?
March 13, 2009 at 2:42 pm
It's possible.
The hostname and many of those metadata fields about the connection are sent through by the driver. They can be overridden easily.
However someone would have to specifically code that. Is it with lots of workstations or just some?
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply