查看某个用户会话连接总数、PGA 内存使用大小

jiawang

   SELECT
       s.INST_ID,
       s.USERNAME,
      COUNT(*) AS session_count,
       SUM(p.pga_alloc_mem)/1024/1024 AS total_pga_mb,
       ROUND(AVG(p.pga_alloc_mem)/1024/1024,2) AS avg_pga_per_session_mb
   FROM gv$session s
   JOIN gv$process p ON s.paddr = p.addr
   WHERE s.username = 'DICOM'
* GROUP BY s.INST_ID, s.username；

登录/注册后可看大图