Oracle 彻底 kill session(二)

2014-11-24 17:54:50 · 作者: · 浏览: 1
0 1

ACTIVE 4C61F6E8 15 4 27610 0 1

ACTIVE 4C620260 222 24 27450 0 1

ACTIVE 4C61FCA4 7 25 27573 0 1

ACTIVE 4C61F12C 6 25 27573 0 1

ACTIVE 4C61EB70 4 24 27458 0 1

ACTIVE 4C61E5B4 1 48 27440 0 1

ACTIVE 4C61DFF8 2 24 27444 0 1

4C624730 0 0 0

4C621950 0 0 0

4C61DA3C 0 0 0




或者根据下面的语句来获得发生变化的addr

sys@AUSTIN> select p.addr from v$process p where pid <> 1

2 minus

3 select s.paddr from v$session s;


ADDR

--------

4C621950

4C624730