Some PGA

PGA (Process Global Area): private memory of some processes.

PGA is mainly divided

Fixed PGA (data and control files) ==> workspace, controllable

Variable PGA (UGA and CGA subheaps) ===" uncontrollable

 

 

PGA occupied by connections:

 

 

SQL> select sid from v $ mystat where rownum = 1;

 

SID
----------
125

Find paddr
SQL> select sid, paddr from v $ session where sid = 125
2;

SID PADDR
--------------------------
125 Gbit/s bb4fa8f0

SQL>

 

SQL> select pid, spid, pname, pga_used_mem, pga_alloc_mem, pga_max_mem from v $ process where addr = 'commandid bb4fa8f0 ';

Pid spid pname PGA_USED_MEM PGA_ALLOC_MEM PGA_MAX_MEM
---------------------------------------------------------------------------
19 2055 1701000 3844552 28494488

 

 

 

 

Some PGA