Solved

SGA_MAX_SIZE cannot set to specified value

Posted on 2004-08-16
7
328 Views
Last Modified: 2013-12-01
I have edited the SGA_MAX_SIZE to 3156187512 for a oracle9i DB thru OEM.
However after applying the changes  the SGA_MAX_SIZE is found to be 3172964752.
Any clues that why I cannot set it to 3156187512 ?

Thx in advance!!!
0
Comment
Question by:damonchong
  • 3
  • 2
7 Comments
 
LVL 61

Expert Comment

by:gheist
ID: 11817750
What is your operating system?  There is big trickery involved to set SGA above 2G on most 32bit systems
0
 

Author Comment

by:damonchong
ID: 11818057
It is Solaris 5.8.
DB version is Oracle9i Enterprise Edition Release
9.2.0.4.0 - 64 bit Production
0
 
LVL 61

Expert Comment

by:gheist
ID: 11818151
you need to edit /etc/system and set SHMMAX to desired value (1.5*1024*1024+100*2048) 3G of 2K pages + 100 pages just in case
0
 

Author Comment

by:damonchong
ID: 11818379
gheist,
sorry but I do not understand why this is so.
The MAX SGA is bring some factor of total Memory or it should be equal to
some combination of other parameters?
0
 
LVL 61

Accepted Solution

by:
gheist earned 50 total points
ID: 11820456
Solaris allocates SHM handles so you can use 2G of shared memory, this is enough for most of common uses. It should always allow some space for system and daemons and logins to run, or swapping will be inevitable.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Verbose logging is used to diagnose garbage collector problems. By default, -verbose:gc output is written to either native_stderr.log or native_stdout.log.   It is also possible to redirect the logs to a user-specified file. This article will de…
Upgrading Tomcat – There are a couple of methods to upgrade Tomcat is to use The Apache Installer is to download and unzip and run the services.bat remove|install Tomcat6 Because of the App that we are working with, we can only use Tomcat 6.…
Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…
Both in life and business – not all partnerships are created equal. As the demand for cloud services increases, so do the number of self-proclaimed cloud partners. Asking the right questions up front in the partnership, will enable both parties …

861 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

25 Experts available now in Live!

Get 1:1 Help Now