Re: table lock (select for update)

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Mon, 19 Nov 2007 16:20:22 -0000
Message-ID: <FumdnQacONBeKtzaRVnyiAA@bt.com>

"Steve Robin" <ocmaman_at_gmail.com> wrote in message news:f64b1c39-6671-491b-aa32-e18a40d224f8_at_o6g2000hsd.googlegroups.com...
> Hi,
> I had been facing a problem in oracle 9.2.0.8 on sun solaris, so many
> session were locked because of a query.
>
> select * from mfs600 for update.
>
> So I kill this sessions as per application team, but when I tried to
> find that query in v$sqlarea ( stats$sql_summary ), I am not able to
> find it.
>
> even when I checked packages, procedure and function body... this
> query was not there also.
>
> Is there any possiblity that oracle did it because of any reason.....
> is oracle has any thing... like package or procedure which locks
> objects for a while.
>
> Please help.

Was the statement exactly the thing you sent, or was it a little different ?

-- 
Regards

Jonathan Lewis
http://jonathanlewis.wordpress.com

Author: Cost Based Oracle: Fundamentals
http://www.jlcomp.demon.co.uk/cbo_book/ind_book.html

The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html

Received on Mon Nov 19 2007 - 10:20:22 CST