How to detect connected web users
Hi,
We have a in house developed application which uses the components shown in the attached diagram.
Our problem is sometimes on database we have many locks and we would like to detect which application user's
behaviour is causing the locks. Ofcourse we can see the database lock and the database user - but not the application user.
Some more information regarding our application and how connection established from application to DB:
RDBMS : 19c
Weblogic Server : 12.2
3 steps to connect to the database.
1-We are using own authentication on portal as login page for the clients (i.e. login.EAR)
2-After login, each user uses web services and each webservice has own data source .