Re: table lock (select for update)

On Nov 19, 4:20 pm, "Jonathan Lewis" <jonat..._at_jlcomp.demon.co.uk> wrote:
> "Steve Robin" <ocma..._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 Lewishttp://jonathanlewis.wordpress.com
>
> Author: Cost Based Oracle: Fundamentalshttp://www.jlcomp.demon.co.uk/cbo_book/ind_book.html
>
> The Co-operative Oracle Users' FAQhttp://www.jlcomp.demon.co.uk/faq/ind_faq.html- Hide quoted text -
>
> - Show quoted text -

yes, it is same. I find that there was locking on sessions.

Regards
Steve Received on Tue Nov 20 2007 - 10:28:50 CST