Re: Oracle Lock Problem(B

From: ddf(B <oratune_at_msn.com>
Date: Fri, 27 Mar 2009 08:31:30 -0700 (PDT)
Message-ID: <5806bd1f-06fd-4670-a050-572f211f797b_at_h5g2000yqh.googlegroups.com>

On Mar 27, 10:04 am, Ming$BGl(B <l..._at_tech-trans.com> wrote:
> Hi,
>
> How can I find the SQL statement that make the table lock?
>
> Ming

You can try this:

select sql_fulltext
from v$sqlarea
where (address, hash_value) in
(select sql_address, sql_hash_value
from v$session
where sid in (select session_id from v$locked_object)) /

Or you can use OEM or TOAD to show you that information.

David Fitzjarrell Received on Fri Mar 27 2009 - 10:31:30 CDT