To check how the total PGA is being allocated by the instance,query the V$PGASTAT dynamic view. : pgastat « System Tables Views « Oracle PL / SQL






To check how the total PGA is being allocated by the instance,query the V$PGASTAT dynamic view.

 
SQL>
SQL> select * from v$pgastat
  2  where rownum < 50;
NAME                      VALUE UNIT
-------------------- ---------- ------------
aggregate PGA target   94371840 bytes
 parameter

aggregate PGA auto t   68705280 bytes
arget

global memory bound    18874368 bytes
total PGA inuse        18112512 bytes
total PGA allocated    36039680 bytes
maximum PGA allocate   40627200 bytes
d

total freeable PGA m          0 bytes
emory

process count                26
max processes count          26
PGA memory freed bac          0 bytes
k to OS

total PGA used for a          0 bytes
uto workareas

maximum PGA used for    7386112 bytes
 auto workareas

total PGA used for m          0 bytes
anual workareas

maximum PGA used for     530432 bytes
 manual workareas

over allocation coun          0
t

bytes processed       433881088 bytes
extra bytes read/wri          0 bytes
tten

cache hit percentage        100 percent
recompute count (tot      13259
al)


19 rows selected.

SQL> --

 








Related examples in the same category