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.

   <source lang="sql">

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

</source>