Home » Fusion Middleware & Colab Suite » Weblogic & Application Server » Tracking session User details in Appserver environment (Oracle 10g with Application Server)
Tracking session User details in Appserver environment [message #644804] Wed, 18 November 2015 02:50 Go to next message
chat2raj.s
Messages: 135
Registered: October 2010
Location: Chennai, India
Senior Member
Dears,

We are using an ERP application in an Portal environment. We need to identify which user is mapped to any particular Oracle session id. From the Toad session browser, it always shows the app server id only for each session. How to identify that particular user/machine that is linked to the session.

Thank you.
Re: Tracking session User details in Appserver environment [message #644809 is a reply to message #644804] Wed, 18 November 2015 04:22 Go to previous messageGo to next message
John Watson
Messages: 8052
Registered: January 2010
Location: Global Village
Senior Member
Look at v$session.client_identifier. Your developers should be setting that (dbms_session.set_identifier) when your users log in to the app if it uses persistent sessions, or with each call if it uses a connection pool.
Re: Tracking session User details in Appserver environment [message #644814 is a reply to message #644809] Wed, 18 November 2015 05:08 Go to previous message
chat2raj.s
Messages: 135
Registered: October 2010
Location: Chennai, India
Senior Member
Thanks a lot Mr.John Watson
Previous Topic: Admin server is not starting
Next Topic: ERROR STARTING ORACLE WEB SERVICES
Goto Forum:
  


Current Time: Mon Nov 18 18:08:29 CST 2019