Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: how to display locked query?
ewong_at_mail.com (Ed Wong) wrote in message news:<a5ae1554.0112110040.7531f5a2_at_posting.google.com>...
> I have a software which makes multiple connections to an oracle
> database. Once a while I got several locks on a particular table and
> the queries just hangs. By query v$locked_object, I can see which
> table is locked and which session ids are reponsible for the lock and
> they are in locked_mode=3. But how can I tell what sqls are locking?
> Can anyone shows me a system query that can shows all the locked up
> sql?
>
> Thanks.
>
> ewong
Ewong,
May be the info from v_$sql about which sql stmts ran since when and
the info that since when the session is locked can be correlated to
get something.
Hope it helps u out ..
Received on Tue Dec 11 2001 - 07:00:51 CST