查看数据库中被锁住的对象和相关会话
select a.sid,a.serial#,a.username,a.program,
c.owner, c.object_name ,a.MACHINE,a.TERMINAL
from v$session a, v$locked_object b, all_objects c
where a.sid=b.session_id and
c.object_id = b.object_id
如果你要操作的对象已经被锁住,则你必须等待或者:
alter system kill session 'a.sid,a.serial#'