From: joe ritter (glestadt4@yahoo.com)
Date: Mon Jun 02 2003 - 10:58:56 EDT
Hello,
I am looking at a client's Sun Enterprise 220R (2 X
UltraSPARC-II 450MHz) running Solaris 7 and Oracle
8.1.7. I have seen the following entries in the logs
that correspond to days when the server has gone to
its knees:
May 27 11:38:37 kn.sr1.com unix: WARNING: /tmp: File
system full, swap space limit exceeded
May 27 11:38:39 kn.sr1.com last message repeated 1
time
May 27 11:38:49 kn.sr1.com sendmail[12917]:
h4RFcCHc012820: SYSERR(root): deliver: fork 2: Not eno
ugh space
May 27 11:38:51 kn.sr1.com unix: WARNING: /tmp: File
system full, swap space limit exceeded
May 27 11:38:51 kn.sr1.com unix: WARNING: Sorry, no
swap space to grow stack for pid 11251 (httpd)
May 27 11:38:51 kn.sr1.com last message repeated 4
times
May 27 11:42:45 kn.sr1.com unix: WARNING: Sorry, no
swap space to grow stack for pid 13259 (sendma
il)
This leads me to believe the following occured.
Physical memory was exceeded and entire processes were
swapped out of main memory. Both main memory and the
swap space were full so no new processes could either
be created or forked. Is this correct?
This machine currently has 2 gigs or real memory
according to prtdiag. Upon inspection of the
/etc/system file I noticed the following parameter
set:
set shmsys:shminfo_shmmax=4294967295
This tells the system that maximum shared memory
segment is 4 Gigs? I believe this parameter is
specified in bytes? If I remember correctly this
parameter tells Oracle how large the SGA can grow
correct? I want to say that the rule of thumb for this
parameter should be 90% of real memory but I am
unsure. If this is correct I should end up with:
2048 * 1024 *1024 *0.9 = 1,932,735,283
If I understand what is happening on this system,
Oracle's SGA is growing too large and the entire
process is being swapped out and the machine is
possibly thrashing at that point? I would like to get
some feedback from any of you. I am not a DBA so this
is maybe a bit out of my league. I am also listing the
rest of the /etc/system parameters here for
completeness:
set shmsys:shminfo_shmmin=1
set shmsys:shminfo_shmmni=256
set shmsys:shminfo_shmseg=10
set semsys:seminfo_semmns=512
set semsys:seminfo_semmni=256
*
set rlim_fd_max=2048
set rlim_fd_cur=256
set priority_paging=1
Thanks in advance.
__________________________________
Do you Yahoo!?
Yahoo! Calendar - Free online calendar with sync to Outlook(TM).
http://calendar.yahoo.com
_______________________________________________
sunmanagers mailing list
sunmanagers@sunmanagers.org
http://www.sunmanagers.org/mailman/listinfo/sunmanagers
This archive was generated by hypermail 2.1.7 : Wed Apr 09 2008 - 23:26:30 EDT