oracle查询被锁的表

select sess.sid,sess.serial#,lo.oracle_username,lo.os_user_name,ao.object_name 被锁表对象名,lo.locked_mode 索模式,sess.login_time 登录数据库时间,

'alter system kill session '''||sess.sid||sess.serial#||''''  freesql

from V#LOCKED_OBJECT LO,DBA_OBJECTS AO ,

V#SESSION SESS WHERE AO.OBJECT_ID=LO.OBJECT_ID AND LO.SESSION_ID=SESS.SID AND ORACLE_USERNAME='库名' order by sid ,sess.serial#;

解锁的话执行最后这列拼接的sql