lock on table by inactive session
One of the programs is inserting & committing into GTT and it was working fine since yesterday.
What is happening now is, the session status is inactive, transaction status is active and it holds row exclusive lock on the GTT and the shell script seems to hang
when I check frm the database, this is what is happening
select * from v$locked_object;
XIDUSN XIDSLOT XIDSQN OBJECT_ID SESSION_ID ORACLE_USERNAME OS_USER_NAME PROCESS
---------- ---------- ---------- ---------- ---------- ------------------------------ ------------------------------ ------------------------
LOCKED_MODE
-----------
60 28 455888 285231 43 CUSTOM devuser 3794
3
Session and Process Information
------------------------------
SID : 43
Serial Number : 75
Oracle User Name : CUSTOM
What is happening now is, the session status is inactive, transaction status is active and it holds row exclusive lock on the GTT and the shell script seems to hang
when I check frm the database, this is what is happening
select * from v$locked_object;
XIDUSN XIDSLOT XIDSQN OBJECT_ID SESSION_ID ORACLE_USERNAME OS_USER_NAME PROCESS
---------- ---------- ---------- ---------- ---------- ------------------------------ ------------------------------ ------------------------
LOCKED_MODE
-----------
60 28 455888 285231 43 CUSTOM devuser 3794
3
Session and Process Information
------------------------------
SID : 43
Serial Number : 75
Oracle User Name : CUSTOM
0