查询进程的pga分配情况

查询进程的pga分配情况

SELECT
    b.sid,
    b.serial#,
    b.program,
    b.status,
    round(a.pga_used_mem/1024/1024,2） pga_used_mem_mb,
    round(a.pga_alloc_mem/1024/1024,2）pga_alloc_mem_mb,
    round(a.pga_freeable_mem/1024/1024,2）pga_freeable_mem_mb,
    round(a.pga_max_mem/1024/1024,2）pga_max_mem_mb
FROM
    v$process a,
    v$session b
WHERE
        a.addr = b.paddr
    AND b.program = 'JDBC Thin Client'
    order by 5 asc;