Oracle PL/SQL/System Tables Views/pgastat

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