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!