RE: per-process limit for Oracle processes on a 64-bit Linux

oracle hard memlock 4195000

Then that's your answer.

Rui Amaral
Database Administrator
ITS - SSG
TD Bank Financial Group
220 Bay St., 11th Floor
Toronto, ON, CA, M5K1A2
(bb) (647) 204-9106  

-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Pawel Kotlarz Sent: Friday, March 25, 2011 12:32 PM
To: oracle-l_at_freelists.org
Subject: per-process limit for Oracle processes on a 64-bit Linux

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-l



NOTICE: Confidential message which may be privileged. Unauthorized use/disclosure prohibited. If received in error, please go to www.td.com/legal for instructions.
AVIS : Message confidentiel dont le contenu peut être privilégié. Utilisation/divulgation interdites sans permission. Si reçu par erreur, prière d'aller au www.td.com/francais/avis_juridique pour des instructions.
--
http://www.freelists.org/webpage/oracle-l