table lock (select for update)

From: Steve Robin <ocmaman_at_gmail.com>
Date: Mon, 19 Nov 2007 08:17:48 -0800 (PST)
Message-ID: <f64b1c39-6671-491b-aa32-e18a40d224f8@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. Received on Mon Nov 19 2007 - 10:17:48 CST