Technology Stack - EBS (MOSC)

MOSC Banner

Proactive monitoring with v$locked_object

edited Oct 1, 2014 5:02AM in Technology Stack - EBS (MOSC) 1 commentAnswered


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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center