如何查看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;

試試這個