SWAP Space Increased from 4 GB to 5.5 GB for RAM=4 GB This Resolved the Problem The Qs. Though Remains That During the Period of the Entire Transactions' Run , the FREE RAM Memory NEVER Fell to Below 2 GB Thanks Mike , List > -----Original Message----- > From: VIVEK_SHARMA [SMTP:[EMAIL PROTECTED]] > Sent: Thursday, April 05, 2001 5:41 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: Unable to Alloc Memory > > > On the SUN APP Server :- > > $ ulimit -a > time(seconds) unlimited > file(blocks) unlimited > data(kbytes) 2097148 > stack(kbytes) 2097148 > coredump(blocks) unlimited > nofiles(descriptors) 1024 > vmemory(kbytes) unlimited > $ ulimit -Hs > 2097148 > > NOTE - On a Digital Inix (5.1) APP Server , The Same Transaction/User > Volume > Runs Successfully Without Error whole ulimit is under :- > > time(seconds) unlimited > file(blocks) unlimited > data(kbytes) 419430 > stack(kbytes) 2097152 > memory(kbytes) 7416080 > coredump(blocks) unlimited > nofiles(descriptors) 4096 > vmemory(kbytes) 2097152 > > > > > -----Original Message----- > > From: Michael Porter [SMTP:[EMAIL PROTECTED]] > > Sent: Wednesday, April 04, 2001 8:28 PM > > To: [EMAIL PROTECTED] > > Subject: Re: Unable to Alloc Memory > > > > Are you sure that this error is not a result of the executing user > having > > insufficient rights (e.g. ulimit) to allocate memory rather than the > > server itself saying that it cannot? > > > > Just a thought, > > > > mike > > > > >>> VIVEK_SHARMA <[EMAIL PROTECTED]> 04/04/01 03:56AM >>> > > CASE When Passing 6600 Transactions spread across 250 Concurrent users > on > > SUN APP Server > > as part of Benchmarking Exercise > > > > Hardware - Sun APP Server 4 CPU , 4 GB RAM , 3.5 GB Swap > > > > Software - Solaris 2.6 on Oracle 7.3.4.5 > > > > Application - Pro*c Application with Embedded SQLs in a Banking Product > > > > ERROR :- > > > > Error Message : [System call failed Error Num [12], Error [Not enough > > space] > > Error : the requested size of memory for allocation was:[131072] > > > > NOTE - > > Minimum FREE Memory measured During the Duration of the Transactions > Run > > (thru vmstat) = 2 GB > > Swap = 3.5 GB > > > > /etc/system :- > > set shmsys:shminfo_shmseg=200 > > set shmsys:shminfo_shmmin=2 > > set shmsys:shminfo_shmmni=200 > > forceload: sys/shmsys > > forceload: sys/semsys > > set semsys:seminfo_semaem=16384 > > set semsys:seminfo_semmap=1000 > > set semsys:seminfo_semmni=1000 > > set semsys:seminfo_semmns=6000 > > set semsys:seminfo_semmnu=1000 > > set semsys:seminfo_semume=200 > > set semsys:seminfo_semvmx=32767 > > set shmsys:shminfo_shmmax=3221225472 > > set c2audit:audit_load = 1 > > set abort_enable = 0 > > *----Added to increase the pttys > > set pt_cnt=512 > > *---Added to increase the no of process per user > > set maxuprc=1024 > > set maxusers=512 > > set nproc=6000 > > *---Added to increase no of open file fd's per process > > set rlim_fd_max=1024 > > set rlim_fd_cur=1024 > > > > Any Advice for any Suitable Setting in /etc/system or ... ? > > > > NOTE - The Identical Transaction Set Succeeds When passed from a > Different > > Compaq Digital Unix APP Server . > > > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: VIVEK_SHARMA INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
