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