search cancel

How to list inactive session which is holding a lock

book

Article ID: 244098

calendar_today

Updated On:

Products

CA Automic Workload Automation - Automation Engine

Issue/Introduction

How to list inactive session which are holding the lock.

 select status,sid,serial#,machine,osuser,LOGON_TIME,LAST_CALL_ET  from
gv$session where username='AUTOMIC_REPO' and status='INACTIVE' order by 6;  2



Environment

Release : 12.3.2

Component : AUTOMATION ENGINE

Resolution

Update sqlnet.ora  ( set the expire_time to minimum value) 
SQLNET.INBOUND_CONNECT_TIMEOUT=150
SQLNET.EXPIRE_TIME=1 

Additional Information

https://docs.oracle.com/cd/E11882_01/network.112/e10835/sqlnet.htm#NETRF216