per-process limit for Oracle processes on a 64-bit Linux
Date: Fri, 25 Mar 2011 17:32:24 +0100
Message-ID: <4D8CC398.1000208_at_go2.pl>
Hi,
recently I hit several memory leak bugs and patched them. The processes (SQL*Net connections) were failing with ORA-4030 when they allocated exactly 4 GB of memory (as seen in V$PROCESS.PGA_ALLOC_MEM). Is there any per-process limit for Oracle running on 64-bit Linux? Or maybe Oracle reports memory allocation incorrectly? I had an SR opened with Oracle but an analyst could not tell me why processes failed always after allocating exactly 4 GB.
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options
$ uname -a
Linux xxx 2.6.9-55.ELsmp #1 SMP Fri Apr 20 16:36:54 EDT 2007 x86_64
x86_64 x86_64 GNU/Linux
$ cat /etc/redhat-release
Red Hat Enterprise Linux AS release 4 (Nahant Update 5)
#limits used by the listener:
$ ulimit -Sa
core file size (blocks, -c) 0 data seg size (kbytes, -d) unlimited file size (blocks, -f) unlimited pending signals (-i) 1024 max locked memory (kbytes, -l) 32 max memory size (kbytes, -m) unlimited open files (-n) 1024 pipe size (512 bytes, -p) 8 POSIX message queues (bytes, -q) 819200 stack size (kbytes, -s) unlimited cpu time (seconds, -t) unlimited max user processes (-u) 2047 virtual memory (kbytes, -v) unlimited file locks (-x) unlimited
Thanks,
Pawel Kotlarz
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Mar 25 2011 - 11:32:24 CDT