quote=引用 2 楼 gioh0022 的回复:] 是你本身库跑得就慢~~或者跟其他操作死锁了~~ select l.session_id, o.owner, o.object_name from v$locked_object l, dba_objects o where l.object_id = o.object_id 发现 [
select l.session_id, o.owner, o.object_name from v$locked_object l, dba_objects o where l.object_id = o.object_idSELECT sid, serial#, username,osuser FROM sys.v_$sessionALTER SYSTEM KILL SESSION '157,16938'; ALTER SYSTEM KILL SESSION '194,6848';好了 我直接KILL掉有没有问题
是你本身库跑得就慢~~或者跟其他操作死锁了~~
select l.session_id, o.owner, o.object_name
from v$locked_object l, dba_objects o
where l.object_id = o.object_id
发现
[
select l.session_id, o.owner, o.object_name
from v$locked_object l, dba_objects o
where l.object_id = o.object_idSELECT sid, serial#, username,osuser
FROM sys.v_$sessionALTER SYSTEM KILL SESSION '157,16938';
ALTER SYSTEM KILL SESSION '194,6848';好了 我直接KILL掉有没有问题