| User details - 3 tier application [message #407679] |
Thu, 11 June 2009 01:21  |
mymot
Messages: 225
Registered: July 2005
|
Senior Member |
|
|
Application : Written in Sun Java
Application : Online orders - Messages in XMLs
Middleware : Sun one application server 7 /JMS
DB : oracle 9.2.0.8
DB connections : using connection pooling
DB Max sessions: 450
Question : How can i find out numbers of connected users & their details on hourly basis.
Thanks
[Updated on: Thu, 11 June 2009 02:08] by Moderator Report message to a moderator |
|
|
|
|
|
| Re: User details - 3 tier application [message #407723 is a reply to message #407691] |
Thu, 11 June 2009 05:17  |
brillix
Messages: 6
Registered: June 2009
|
Junior Member |
|
|
You can only see the connections are currently connected to the database - because you are using connection pooling several users can use one connection.
select * from v$session where MACHINE = '<Your application server machine name>'
You can use oracle context / client_identifier but you will have to adjust the application to support that change.
Example :
In the application set the following before each user start using the connection :
execute dbms_session.set_identifier('Some_Identifier')
You can then get the information from v$session using :
select client_identifier
from v$session
where MACHINE = '<Your application server machine name>'
Oded
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
