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
               -V3)

D000  oracle   oracle@aix24 (D000)              1.03887272              1.30467415                          0            1.30467415
      cbstestc oracle@aix24 (TNS V1             1.04064274               2.3126545                         .5             2.6251545
               -V3)


PNAME USERNAME PROGRAM              PGA_USED_MEM/1024/1024 PGA_ALLOC_MEM/1024/1024 PGA_FREEABLE_MEM/1024/1024 PGA_MAX_MEM/1024/1024
----- -------- -------------------- ---------------------- ----------------------- -------------------------- ---------------------
CJQ0  oracle   oracle@aix24 (CJQ0)              1.33648872              11.6251545                     9.9375            11.6251545
      oracle   oracle@aix24                     1.36362648              2.55467415                      .8125            9.36717415
Q000  oracle   oracle@aix24 (Q000)              1.37020302              1.99217415                      .4375            1.99217415
      cbstestb oracle@aix24 (TNS V1             1.69078922               3.6876545                          1             7.8126545
               -V3)

MMON  oracle   oracle@aix24 (MMON)              1.94095039              4.42138863                      2.125            4.42138863
      cbstestb oracle@aix24 (TNS V1             4.00235844               5.8751545                          1             7.0626545
               -V3)

DIA0  oracle   oracle@aix24 (DIA0)              5.05288887              6.85888863                     1.3125            6.85888863
DBW0  oracle   oracle@aix24 (DBW0)              8.07191658              46.6645069                     38.375            46.6645069
LGWR  oracle   oracle@aix24 (LGWR)              10.8246479              11.9838886                      .4375            11.9838886


PGA_USED_MEM	NUMBER	PGA memory currently used by the process (in bytes)

进程使用的PGA大小,单位字节

PGA_ALLOC_MEM	NUMBER	PGA memory currently allocated by the process (including free PGA memory not yet released to the operating system by the server 

process), in bytes

进程使用的PGA大小,包括没有被OS回收的PGA内存

PGA_FREEABLE_MEM	NUMBER	Allocated PGA memory which can be freed (in bytes)


PGA_MAX_MEM	NUMBER	Maximum PGA memory ever allocated by the process (in bytes)