摘要:
查询被锁表的ID:selectb.owner,b.object_name,a.session_id,a.locked_modefromv$locked_objecta,dba_objectsbwhereb.object_id=a.object_id;查找被锁表的字段ID:selectb.username,b.sid,b.serial#,logon_timefromv$locked_objecta,v$sessionbwherea.session_id=b.sidorderbyb.logon_time;解锁表:ALTERSYSTEMKILLSESSION'131,648'; // 阅读全文