| "ORA-27102: out of memory" and SGA [message #389207] |
Fri, 27 February 2009 10:56  |
gatsby
Messages: 22
Registered: March 2006
|
Junior Member |
|
|
I am running a Oracle 10.2.0.4 database instance (32-bit) on a Solaris 10x86 machine. I have about 16GB of RAM on this machine.
When I set my sga_max_size and sga_target to a value over ~3000M (something like 7000M) and try to start it through SQL*Plus, I get a "ORA-27102: out of memory" error. The database will not start. The only resolution I have found for this error is to lower the SGA parameters back to ~3000M or below, and the database then starts up normally. I would like to assign more than 3GB of memory to the SGA if possible.
I created a project that should be assigning my oracle user access to 10GB of memory, but this does not seem to be working.
%> prctl -n project.max-shm-memory -i project user.oracle
project: 100: user.oracle
NAME PRIVILEGE VALUE FLAG ACTION RECIPIENT
project.max-shm-memory
privileged 10.0GB - deny -
system 16.0EB max deny -
Is there something in the 32-bit version of Oracle that does not allow the SGA to exceed ~3GB? Am I overlooking something? Thanks in advance.
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
