解锁表

以dba权限登录：sqlplus / as sysdba

1.查看被suo锁住的表：

select b.owner,b.object_name,a.session_id,a.locked_mode from v$locked_object a,dba_object b where b.object_id=a.object_id;

2.查看bi表锁、行锁

select s.sid,s.serial# from v$session s,v$lock l where s.sid=l.sid and s.username is not null order by  s.sid;

3.杀掉进程

alter system kill session '210,11562';