查询Session:
SELECT se.username, se.SID, se.serial#, pr.spid, se.status,
SUBSTR (se.program, 1, 10) prog, SUBSTR (se.machine, 1, 10) mach,
sq.sql_text
FROM v$session se, v$sqlarea sq, v$process pr
WHERE se.paddr = pr.addr(+)
AND se.sql_address = sq.address(+)
AND schemaname <> 'SYS'
AND se.username = 'STAGINGTEST'
ORDER BY se.SID
杀死Session:
ALTER SYSTEM KILL SESSION '26,11466';
以上都要以System的身份去执行。。。