Solved

SGA_MAX_SIZE cannot set to specified value

Posted on 2004-08-16
7
327 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

What Security Threats Are You Missing?

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
How to get rid of Java update popups 6 216
Not able to update Java 5 200
java question on merging xls 3 68
Multi-threading in Tomcat 4 90
Configure Web Service (server application) I. Configure security for Web Services methods First, we need to protect Session bean which implements the service: 1. Open EJB deployment descriptor (ejb-jar.xml) in the EJB project that contains you…
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.…
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…

747 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

13 Experts available now in Live!

Get 1:1 Help Now