Re: get the sql producing lock

On 19 Mar 2006 05:12:01 -0800, cnwy_at_263.net wrote:

>Hello,
> Is there a simple way to get the sql statement which locked the
>object in a transaction?
>

I am not aware of 'current transaction sql'.

However, you can look into v$session.sql_hash_value for last sql executed (or more like currently executing sql).

For past sql executed by the session, you can look into v$open_curosr. .......
We run Oracle 9.2.0.6 on RH4 AMD
remove NSPAM to email Received on Mon Mar 20 2006 - 11:34:52 CST