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