Out of Memory Error on Linux Server
I have a Server:
O.S: Linux RHEL AS 3.0 Update 5 Taroon
RAM: 16 GB
SGA: 2.8 GB
My Server gives me Out of Process Memory Error at times.
I am using Normal Kernel for Booting and not Huge Mem Kernel.
Please advise, if booting from HugeMem Kernel may solve the Problem?
use automatic pga allocation
"I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."
"Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"
What does Automatic pga allocation exactly mean, is it oracle 9i feature or oracle 10g
Post the results of ulimit -a and let's take it from there...
Originally Posted by KenEwald
core file size (blocks, -c) 0
data seg size (kbytes, -d) unlimited
file size (blocks, -f) unlimited
max locked memory (kbytes, -l) 4
max memory size (kbytes, -m) unlimited
open files (-n) 1024
pipe size (512 bytes, -p) 8
stack size (kbytes, -s) 10240
cpu time (seconds, -t) unlimited
max user processes (-u) 7168
virtual memory (kbytes, -v) unlimited
Any Updates from anybody ?
you should use SMP or Huge Mem Kernel if you have 16GB Memory
Does it require, the Server to be booted with Huge Mem Kernel prior to oracle software installation
is it Ok, if i do boot the Server now after oracle software installation, the latter i have tried and failed to resolve the problem.
first of all show us the EXACT error message
When i successfully booted from Huge Mem Kernel and tried starting my database:
It gave me an error:
Unable to attach shared memory segment.
We tried to lower the SGA_max_size and tried again, but with same error.
Last edited by pareshjavkar; 10-17-2006 at 02:58 AM.
Click Here to Expand Forum to Full Width