Re: get the sql producing lock

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.

wy. Received on Mon Mar 20 2006 - 19:17:14 CST