摘要:
1)锁表查询语句SQL语句如下 :selectt2.username,t2.sid,t2.serial#,t2.logon_timefromv$locked_objectt1,v$sessiont2 wheret1.session_id=t2.sidorderbyt2.logon_time2)查询锁表的详细信息select dba_objects.object_name, v$locked_object.oracle_username,v$locked_object.os_user_name,v$locked_object.locked_mode,v$session.process,v$ses 阅读全文