话不多说，直接上语句了，

##查询oracle数据库中，吃内存 usage 最多的那些进程

SELECT s.sid, s.serial#, s.username, s.program, SUM(value/1024/1024) AS memory_usage

FROM v$sesstat ss, v$statname sn, v$session s

WHERE sn.name = 'session uga memory'

AND ss.statistic# = sn.statistic#

AND ss.sid = s.sid

GROUP BY s.sid, s.serial#, s.username, s.program

ORDER BY 5 DESC

###查到进程就强制杀掉，自行 sqlplus / as sysdba  

ALTER SYSTEM KILL SESSION '4698,19163' immediate;