Oracle解表锁

锁表:lock table r_zoning_basetab in exclusive mode nowait;

以DBA身份登录sqlplus,执行以下命令:
1.select session_id,serial# from V$locked_Object l,V$session s where l.SESSION_ID=s.SID;
2.alter system kill session 'session_id,serial#';

以上是最简单的方式

也可以:select object_id,session_id,serial#,oracle_username,os_user_name,s.process from v$locked_object l,v$session s where l.SESSION_ID=s.SID;查看oralce用户名直接解锁用户:

alter user 用户名 account unlock;