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

Is there are a way to determine that it was locked via such a statement?
The only other thing I looked at was v$open_cursor, and it had nothing related to this table.. is 'lock table X' even a sql statement? (seems so to me)

thnx.
On Mon, 25 Apr 2005 17:21:04 +0000 (UTC), "Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> wrote:

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

.......
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 - 15:56:02 CDT