Re: How to identify the jboss tread number inside Oracle 12.2.x

Hi Mikhail ,

According Oracle docs, in the gv$session, the column port refers to the Client port number, so it is what I am looking for. The database uses the Resource Manager, but the idle_time control is high, so this is the reason I am investigating the INACTIVE session.

Thanks for information and clues.
I will check all suggested material.

Regards
Eriovaldo

Em sáb., 17 de abr. de 2021 às 14:48, Mikhail Velikikh <mvelikikh_at_gmail.com> escreveu:

> Hey,
>
> I would use V$SESSION.PORT. Then you can use netstat/ss on your app server
> to see what process is listening on that port.
> It sounds like you want to implement your own Dead Connection Detection
> (DCD) mechanism:
> https://www.oracle.com/technetwork/database/enterprise-edition/oraclenetdcd-2179641.pdf
>
> Additionally please take a look at:
>
> https://docs.oracle.com/en/database/oracle/oracle-database/19/refrn/MAX_IDLE_TIME.html
>
> https://docs.oracle.com/en/database/oracle/oracle-database/19/refrn/MAX_IDLE_BLOCKER_TIME.html
>
> I see that MAX_IDLE_TIME is in 12.2. MAX_IDLE_BLOCKER_TIME is not there,
> but you can do the same via Database Resource Manager (DBRM):
>
> https://docs.oracle.com/en/database/oracle/oracle-database/12.2/arpls/DBMS_RESOURCE_MANAGER.html#GUID-8EC6C735-338D-46D4-B346-AD16D0622B30
>
> You can also use profiles to set IDLE_TIME:
> https://docs.oracle.com/en/database/oracle/oracle-database/12.2/sqlrf/CREATE-PROFILE.html#GUID-ABC7AE4D-64A8-4EA9-857D-BEF7300B64C3
> The MOS article discussing how some of these restrictions relate to one
> another:
> A discussion of Dead Connection Detection, Resource Limits, V$SESSION,
> V$PROCESS and OS processes (Doc ID 601605.1)
>
> Best regards,
> Mikhail Velikikh
>
>
>
> On Sat, 17 Apr 2021 at 14:22, Eriovaldo Andrietta <ecandrietta_at_gmail.com>
> wrote:
>
>> Hello,
>>
>> I have the following scenario in Oracle 12.2.x:
>>
>> Sometimes, connections that are opened by Jboss (connection pool) stay
>> INACTIVE in the gv$session and with the event "waiting for the client to
>> respond" and if they are in transaction, they get locked in the gv$lock.
>> In my concern , it happens because the Jboss lost the connection with the
>> database server while running.
>>
>> The Application has a timeout configured and also has a process to do the
>> node redir in intervals of 24 hours.
>>
>> I would like to know if there is a way in Oracle to identify the number
>> of the Jboss thread that opened the connection in order to track in the
>> application server and check if it is still active.
>>
>> Regards
>> Eriovaldo
>>
>>

--
http://www.freelists.org/webpage/oracle-l