Home » RDBMS Server » Security » User details - 3 tier application (Oracle 9.2.0.8, Unix Sun solaris 5.8)
User details - 3 tier application [message #407679] Thu, 11 June 2009 01:21 Go to next message
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 #407691 is a reply to message #407679] Thu, 11 June 2009 02:09 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Oracle can only tell you the database connections not the application server ones.

Regards
Michel
Re: User details - 3 tier application [message #407723 is a reply to message #407691] Thu, 11 June 2009 05:17 Go to previous message
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

Previous Topic: How to reset encyption key (wallet removal)
Next Topic: Determine locked users from sqlplus?
Goto Forum:
  


Current Time: Thu Mar 28 12:33:40 CDT 2024