Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: locked_mode=3, no open transactions on the table?
It seems a little unlikely, but in principle TOAD could have issued:
lock table X in row exclusive mode;
No transaction, just a TM lock protecting the table.
-- Regards Jonathan Lewis http://www.jlcomp.demon.co.uk/faq/ind_faq.html The Co-operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/seminar.html Public Appearances - schedule updated April 5th 2005 "NetComrade" <netcomradeNSPAM_at_bookexchange.net> wrote in message news:426d2763.2316252474_at_localhost...Received on Mon Apr 25 2005 - 12:21:04 CDT
> 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