"What are the risks of increasing pga_aggregate_target, is it safe to do?
Hi MOSC,
Given:
plenty of available free memory in oda rac system (180 GB - after taking in account OS and all database/rac memory usage)
cluster database uses automatic shared memory mode
PGA comes from OS bucket
v$pga_target_advice show an increase in performance by adjusting PGA to 20GB
Now:
SGA 48 GB
PGA 08 GB
Will be:
SGA 48 GB
PGA 20 GB
Via:
alter system set pga_aggregate_target=20G scope=both sid='*';
Mgmt question;
"
If we increase pga;
1) How safe is that action?
2) What are the risks?
"
DBAs:
So far we just have;
As the parameter is dynamic, there is no concern or need for a database bounce so therefore no need for downtime and risking client productivity/access.