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: 161
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: 8919
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: 161
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: Tue Mar 19 03:06:53 CDT 2024