如何查看oracle每个连接占用的内存大小 – 数据库 – 前端

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;

试试这个