SELECT * FROM V$PGASTAT

SQL> SELECT NAME FROM V$PGASTAT;

NAME

----------------------------------------------------------------

aggregate PGA target parameter

aggregate PGA auto target

global memory bound

total PGA inuse

total PGA allocated

maximum PGA allocated

total freeable PGA memory

process count

max processes count

PGA memory freed back to OS

total PGA used for auto workareas

maximum PGA used for auto workareas

total PGA used for manual workareas

maximum PGA used for manual workareas

over allocation count

bytes processed

extra bytes read/written

cache hit percentage

recompute count (total)

19 rows selected.