How to increase SGA_MAX_SIZE and PGA_AGGREGATE_TARGET in 10g RAC
665881Aug 13 2009 — edited Aug 16 2009All,
We have built new RAC environment with following configurations.
Linux - RHEL5
Oracle - 10.2.0.4.0
2 Node RAC environment.
Now the database is on live.
1. Now, I need to increase the SGA_MAX_SIZE and PGA_AGGREGATE_TARGET in this RAC environment.
Can somebody tell me the steps. Do I need to shutdown the database?
Note: Still OEM is not setup for this one.
2. Performance Testers are complaining about "High Response Time". Any guidance on this one?