How to identify server client requester in the Oracle 12.2.x

From: Eriovaldo Andrietta <ecandrietta_at_gmail.com>
Date: Sat, 10 Jul 2021 20:13:02 -0300
Message-ID: <CAJdDhaO99QPhG=1VTvuc4yrk2KSQy_maoQaiBafnEJh4NtsfDA_at_mail.gmail.com>



Hi all,

I have a session that was used in a transaction and during it some tables had inserted lines, or updated lines or deleted lines via Java Application. I see it in the gv$session : There is a session that is INACTIVE, with tables in lock (Row Exclusive and Row Share) and also the event is : SQL*Net message from client.
The client Java application uses the Jboss (connection pool) , so it can use "another session" to request data using a SELECT data from some table in order to continue the process. It is normal (without committing the other session that has locked tables).

The issue is :

The Java application shows that it is waiting for the data and the database says that the session is waiting for the client.

My doubts are :

a.) In the locked session I can see in the gv$session.port a value.

     Is this the Client port in the network ?
     If yes, can I use this data to inform the application team to locate
the jboss stack at the client application server ?

b.) Considering this scenary, I donĀ“t have another ACTIVE session, I have only the session that was used for locking the tables as mentioned above.

     Is there a way to locate the another session used by the Application in the database ?

     What is the information from the client server , like client server pid or jboss stack number that I can use to identify it in the Oracle database ?

Regards
Eriovaldo

--
http://www.freelists.org/webpage/oracle-l
Received on Sun Jul 11 2021 - 01:13:02 CEST

Original text of this message