9i如何确认每个连接用户占用的内存量 红太狼 2021-06-24 13:59 155阅读 0赞 select b.PGA\_USED\_MEM PGA\_USED\_MEM, b.PGA\_ALLOC\_MEM PGA\_ALLOC\_MEM, b.PGA\_FREEABLE\_MEM PGA\_FREEABLE\_MEM,b.PGA\_MAX\_MEM PGA\_MAX\_MEM from v$session a, v$process b where a.PADDR=b.ADDR and a.sid ='&sid' select a.sid, b.name, sum(value)/1024/1024 from v$sesstat a, v$statname b where a.statistic\#=b.statistic\# and b.name like '%pga%' group by sid,name \[@more@\]
还没有评论,来说两句吧...