Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> locked_mode=3, no open transactions on the table?

locked_mode=3, no open transactions on the table?

From: NetComrade <netcomradeNSPAM_at_bookexchange.net>
Date: Mon, 25 Apr 2005 17:25:55 GMT
Message-ID: <426d2763.2316252474@localhost> 





We had a weird case where a table was locked in locked_mode=3,
however, when I looked at transactions, there were no transactions on
the table.


The lock was causing a truncate to fail on this table.
The session was a TOAD session from a computer that died.
As soon as session was killed, truncate could go ahead.
Am I missing something?


.......


We use Oracle 8.1.7.4 and 9.2.0.5 on Solaris 2.7 boxes
remove NSPAM to email
Received on Mon Apr 25 2005 - 12:25:55 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US