方法:执行下列语句
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博客 ” ,链接:http://blog.itpub.net/252936/viewspace-711536/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/252936/viewspace-711536/