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 -> Re: locked_mode=3, no open transactions on the table?

Re: locked_mode=3, no open transactions on the table?

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Mon, 25 Apr 2005 17:21:04 +0000 (UTC)
Message-ID: <d4j8u0$pr$1@nwrdmz03.dmz.ncs.ea.ibs-infra.bt.com>

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...

> 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:21:04 CDT

Original text of this message

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