PGA 内存管理

select pname,
       username,
       program,
       pga_used_mem / 1024 / 1024,
       pga_alloc_mem / 1024 / 1024,
       pga_freeable_mem / 1024 / 1024,
       pga_max_mem / 1024 / 1024
  from v$process
 order by 4, 7
PNAME USERNAME PROGRAM              PGA_USED_MEM/1024/1024 PGA_ALLOC_MEM/1024/1024 PGA_FREEABLE_MEM/1024/1024 PGA_MAX_MEM/1024/1024
      cbstesta oracle@aix24 (TNS V1             .999917984               2.2501545                      .8125             2.2501545
               -V3)

      cbstestb oracle@aix24 (TNS V1             1.00030613               2.1251545                      .8125             6.1876545
               -V3)

      cbstestb oracle@aix24 (TNS V1             1.02668095               2.2501545                        .75             2.8751545
               -V3)

      cbstestb oracle@aix24 (TNS V1             1.02713108               2.4376545                      .9375             2.4376545