How to identify server client requester in the Oracle 12.2.x
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 :
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 locatethe 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-lReceived on Sun Jul 11 2021 - 01:13:02 CEST