-
pga_aggregate_target
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|