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!!!
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!!!
What is your operating system? There is big trickery involved to set SGA above 2G on most 32bit systems
ASKER
It is Solaris 5.8.
DB version is Oracle9i Enterprise Edition Release
9.2.0.4.0 - 64 bit Production
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
ASKER
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?
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.