Proactive monitoring with v$locked_object
We have database version 11.2.0.3 and EBS version 12.1.3
I want to have a query that proactively monitors the locked objects by user. If anything is more than one day, then I would proceed to kill the session.I have the following query. However, I want to add username to the query results. I have tried to use the username in v$session column, but all of those returns apps user. I would like to use the actual username which is the column in fnd_user table. However, there seems to be no common column that I can join fnd_user table to this query. In the user monitor page at the oracle