摘要：
1、查出被锁的表。SELECT lpad(' ',decode(l.xidusn ,0,3,0))||l.oracle_username User_name, o.owner,o.object_name,o.object_type,s.sid,s.serial# FROM v$locked_object l,dba_objects o,v$session s WHERE l.object_id=o.object_id AND l.session_id=s.sid ORDER BY o.object_id,xidusn DESC; 我这里查询出有一个表被锁了：2、解锁--alte 阅读全文
posted @ 2012-09-17 16:24 CN.programmer.Luxh 阅读(453) 评论(0) 推荐(0) 编辑