[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

SGA_MAX_SIZE cannot set to specified value

Posted on 2004-08-16
7
Medium Priority
?
339 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
5 Comments
 
LVL 62

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 62

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 62

Accepted Solution

by:
gheist earned 200 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

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Question has a verified solution.

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

Most of the developers using Tomcat find it easy to configure the datasource in Server.xml and use the JNDI name in the code to get the connection.  So the default connection pool using DBCP (or any other framework) is made available and the life go…
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.…
Integration Management Part 2
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …
Suggested Courses
Course of the Month19 days, 20 hours left to enroll

873 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