查看会话内存占用情况
SELECT server "连接类型",
s.username,
OSUSEr,
NAME,
VALUE/1024/1024 "占用内存MB",
s.SID "会话ID",
s.serial#,
spid "操作系统进程ID",
p.PGA_USED_MEM,
p.PGA_ALLOC_MEM,
p.PGA_FREEABLE_MEM,
p.PGA_MAX_MEM
FROM v$session s, v$sesstat st, v$statname sn, v$process p
WHERE st.SID = s.SID
AND st.statistic# = sn.statistic#
AND sn.NAME LIKE 'session pga memory'
AND p.addr = s.paddr
ORDER BY VALUE DESC
如果想杀死指定会话alter system kill session 'sid,serial#';,内存没有释放执行如下步骤;
select a.spid,b.sid,b.serial#,b.username from v$process a,v$session b where a.addr=b.paddr and b.status='KILLED' ;
查看killed状态的会话,
windows下:orakill.exe orcl spid,其中orcl是数据库的sid,spid是上面查询出来的
linux下&