方法：执行下列语句

SELECT SUBSTR(d.user_name,1,30) "User Name"
, a.pid
, b.sid
, b.serial#
FROM v$process a, v$session b, fnd_logins c, fnd_user d
WHERE a.pid = c.pid
AND c.pid = &PID
AND d.user_name = UPPER('&USER_NAME')
AND d.user_id = c.user_id
AND a.addr = b.paddr
AND c.end_time IS NULL

其中&PID输入“Oracle进程”列，&USER_NAME输入“用户名”栏，根据获得的SID和SERIAL#，是用以下语句来KILL SESSION:
ALTER SYSTEM KILL SESSION ‘[SID],[SERIAL#]’

ITPub博客

Oracle DBA 技术支持--11i 中怎样kill在监控用户列表中处于inactive的用户？

最新文章