Solved

SGA_MAX_SIZE cannot set to specified value

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

Portable, direct connect server access

The ATEN CV211 connects a laptop directly to any server allowing you instant access to perform data maintenance and local operations, for quick troubleshooting, updating, service and repair.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Define alias for servlet 5 56
tomat 8 server option not available in eclipse 8 117
ColdFusion Application log reports a 'Java heap space' error 6 316
multithreading example 7 134
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…
This video shows how to use Hyena, from SystemTools Software, to bulk import 100 user accounts from an external text file. View in 1080p for best video quality.
Established in 1997, Technology Architects has become one of the most reputable technology solutions companies in the country. TA have been providing businesses with cost effective state-of-the-art solutions and unparalleled service that is designed…

856 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