Select Server, Osuser, Name, Value / 1024 / 1024 Mb, s.Sql_Id, Spid, s.*
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;
试试这个
如果觉得《如何查看oracle每个连接占用的内存大小 – 数据库 – 前端》对你有帮助,请点赞、收藏,并留下你的观点哦!