Solved

SGA_MAX_SIZE cannot set to specified value

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

On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Is vFabric an PaaS 1 146
Java TXT, RTF, DOC, DOCX to PDF converter 3 473
tomcat users xml 7 139
getSandwich  java challenge 22 107
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…
This exercise is about for the following scenario: Dmgr and One node with 2 application server. Each application server contains it owns application. Application server name as follows server1 contains app1 server2 contains app1 Prereq…
How to Install VMware Tools in Red Hat Enterprise Linux 6.4 (RHEL 6.4) Step-by-Step Tutorial

749 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