RE: per-process limit for Oracle processes on a 64-bit Linux
- From: "Amaral, Rui" <Rui.Amaral@xxxxxxxxxxxxxxxx>
- To: "'pkotla@xxxxxx'" <pkotla@xxxxxx>, "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 25 Mar 2011 13:59:03 -0400
Look at you /etc/security/limits.conf file. If you have the following:
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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Pawel Kotlarz
Sent: Friday, March 25, 2011 12:32 PM
To: oracle-l@xxxxxxxxxxxxx
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
--
//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.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
