检查数据库中被锁定(执行完操作未commit)的表:
select object_name,machine,s.sid,s.serial#
from v$locked_object l,dba_objects o ,v$session s
where l.object_id = o.object_id and l.session_id=s.sid;
将被锁定的表解锁:
alter system kill session '482,9181'(查回的表中的后两个字段)
检查数据库中被锁定(执行完操作未commit)的表:
select object_name,machine,s.sid,s.serial#
from v$locked_object l,dba_objects o ,v$session s
where l.object_id = o.object_id and l.session_id=s.sid;
将被锁定的表解锁:
alter system kill session '482,9181'(查回的表中的后两个字段)
190

被折叠的 条评论
为什么被折叠?
