Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

How to increase SGA_MAX_SIZE and PGA_AGGREGATE_TARGET in 10g RAC

665881Aug 13 2009 — edited Aug 16 2009
All,

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?
This post has been answered by Surachart Opun on Aug 13 2009
Jump to Answer

Comments

Processing
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Sep 13 2009
Added on Aug 13 2009
6 comments
60,511 views