kingkongII 发表于 2011-12-23 01:22

oracle 锁表SQL查询

<DIV>
<P>select * from v$locked_object t1,dba_objects t2,v$session t3,v$process t4<BR>where t1.OBJECT_ID=t2.object_id<BR>and t1.SESSION_ID=t3.SID<BR>and t3.PADDR=t4.ADDR</P></DIV>
页: [1]
查看完整版本: oracle 锁表SQL查询