操作数据库时锁表后怎么解决

----① 查看用户锁表
select sess.sid,
sess.serial#,
lo.oracle_username,
lo.os_user_name, --用户名
ao.object_name, --表名
lo.locked_mode
from v$locke{d}_{o}bjectlo,db{a}_{o}bjectsao,v$session sess
where ao.object_id = lo.object_id and lo.session_id = sess.sid

----② 解锁语句
alter system kill session ‘sid,serial#’