Chinaunix's Archiver
论坛
›
Oracle
› oracle 锁表SQL查询
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查询