Skip to Main Content
Forums

Oracle Database Discussions

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.

SGA size and Memory limits

YoavApr 11 2011 — edited Apr 11 2011
Hello,
Version 10204 , on linux redhat 4.8

I have a machine with 32 GB memory . Only 12 GB is set for the SGA , 6 Gb is set for the PGA .
12 Gb are free.

one hour ADDM report advice to increase the size of the SGA to 24 GB :
   RECOMMENDATION 1: DB Configuration, 12% benefit (192423 seconds)
      ACTION: Increase the size of the SGA by setting the parameter  "sga_target" to 24576 M.

   ADDITIONAL INFORMATION:
      The value of parameter "sga_target" was "12288 M" during the analysis period.
Is there a best practice for how much i can increase the SGA without getting ORA-4031 ? can i safely set it to 20GB ?

$ free -m
             total       used       free     shared    buffers     cached
Mem:         32170      19522      12648          0        165      13868
-/+ buffers/cache:       5488      26682
Swap:        20462        552      19910
 show parameter ga
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
lock_sga                             boolean     FALSE
pre_page_sga                         boolean     FALSE
sga_max_size                         big integer 12G
sga_target                           big integer 12G
pga_aggregate_target                 big integer 6G

Comments

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

Post Details

Locked on May 9 2011
Added on Apr 11 2011
#general-database-discussions
1 comment
364 views