Hi, guys
I found TS lock in the v$lock view, with value for ctime is equivalent of several days.
Code:
SVRMGR> select * from v$lock;
ADDR KADDR SID TY ID1 ID2 LMODE REQUEST CTIME BLOCK
-------- -------- ---------- -- ---------- ---------- ---------- ---------- ---------- ----------
334AAA08 334AAA18 5 TS 3 16778570 3 0 494274 0
SQL statement for that session is
Code:
SQL> SELECT a.sql_text FROM v$sqlarea a WHERE (a.address, a.hash_value) IN (SELECT sql_address, sql_hash_value FROM v$session WHERE sid=5);
SQL_TEXT
--------------------------------------------------------------------------------
select f.file#, f.block#, f.ts#, f.length from fet$ f, ts$ t where t.ts#=f.ts# a
nd t.dflextpct!=0 and t.bitmapped=0
Question: is there any way to fix it withour restarting Oracle
/Oracle 8.1.7/
Thank you for any advice!