用了no_merge后返回结果很快!
select /*+ no_merge(v$lock) no_merge(v$session) */
username ,machine ,v$lock.sid ,v$session.serial#,trunc(id1/power(2,16)) rbs ,
bitand(id1,to_number('ffff','xxxx'))+0 slot,
id2 seq,lmode ,request ,program,'alter system kill session '||''''||v$lock.sid||','||v$session.serial#||''''
from v$lock ,v$session
where v$lock.sid = v$session.sid and v$lock.type = 'TX';
------这个很快返回结果
select
username ,machine ,v$lock.sid ,v$session.serial#,trunc(id1/power(2,16)) rbs ,
bitand(id1,to_number('ffff','xxxx'))+0 slot,
id2 seq,lmode ,request ,program,'alter system kill session '||''''||v$lock.sid||','||v$session.serial#||''''
from v$lock ,v$session
where v$lock.sid = v$session.sid and v$lock.type = 'TX';
------这个半天都没有返回结果,并且数据库cpu升高到72%
http://www.itpub.net/showthread.php?s=&postid=7363448#post7363448
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/7916042/viewspace-912373/ ，如需转载，请注明出处，否则将追究法律责任。
