Re: Oracle Lock Problem

From: ddf <>
Date: Fri, 27 Mar 2009 08:31:30 -0700 (PDT)
Message-ID: <>

On Mar 27, 10:04 am, Ming伯 <> 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

Original text of this message