Re: get the sql producing lock

On 20 Mar 2006 17:17:14 -0800, cnwy_at_263.net wrote:

>Thanks,
> I have tried v$open_cursor but can't get all sqls for that
>transaction which locks the table.
> eg.
> 1. select * from emp where enpno = 'xxx' for update; #lock the table
> 2. select .... #other sql
> 3. select .... #other sql
> before the transaction commit or rollback,I tried
>v$open_curosr,v$session but fail to get the first sql and even the
>second.

v$open_cursor only lists 'open' cursors.. it's not guaranteed to have all sql.

.......
We run Oracle 9.2.0.6 on RH4 AMD
remove NSPAM to email Received on Tue Mar 21 2006 - 10:03:26 CST