Link to home
Start Free TrialLog in
Avatar of damonchong
damonchong

asked on

SGA_MAX_SIZE cannot set to specified value

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!!!
Avatar of gheist
gheist
Flag of Belgium image

What is your operating system?  There is big trickery involved to set SGA above 2G on most 32bit systems
Avatar of damonchong
damonchong

ASKER

It is Solaris 5.8.
DB version is Oracle9i Enterprise Edition Release
9.2.0.4.0 - 64 bit Production
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
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?
ASKER CERTIFIED SOLUTION
Avatar of gheist
gheist
Flag of Belgium image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial