Performance - EBS (MOSC)

MOSC Banner

How identify client\IP who execute a sql oracle

Hi Team,

We have EBS R12.2.11 and database on 11g.

We are looking for a way to identify the client or IP running a blocking query.

With a simple query SELECT * FROM V$SESSION, V$PROCESS, V_$SESS_IO, v$lock 

we can identify if there are blocking sessions in our database, but in this way we go back to the SID and the USERNAME, not to the client or IP of the actual user.

Do you know a way or more to actually find out who is blocking what?

Thanks a lot for your support,

Alberto

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

EBS Performance Tags

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center