Hello,

column name format a60
column value format 999,999,999

select name, value from v$pgastat;

When I ran the above sql statment, I do not see the following lines in the output:

estimated PGA memory for optimal
maximum PGA memory for optimal
estimated PGA memory for one-pass
maximum PGA memory for one-pass

Should I enable any other parameters other than the following one's:
pga_aggregate_target big integer 209715200
workarea_size_policy string AUTO

Thanks,
Nikee