The reason for the error ORA-04030: out of process memory?


Warning: count(): Parameter must be an array or an object that implements Countable in /home/styllloz/public_html/qa-theme/donut-theme/qa-donut-layer.php on line 274
0 like 0 dislike
19 views
Good afternoon.

The question is not as simple as it may seem at first sight.. Have an environment Solaris x64. There is one (or at least should be one) instance of Oracle.

RAM: 132Gb

Trying to put these parameters:
DB_CACHE_ADVICE = 'OFF'
NLS_LENGTH_SEMANTICS = CHAR
MEMORY_MAX_TARGET = 0
MEMORY_TARGET = 0
SGA_MAX_SIZE = 10G
SGA_TARGET = 10G
PGA_AGGREGATE_TARGET = 4GB
DB_CACHE_SIZE = 5G
SHARED_POOL_SIZE = 1G
SHARED_POOL_RESERVED_SIZE = 35M
RESULT_CACHE_MAX_SIZE = 25M
DB_KEEP_CACHE_SIZE = 100M


But after restarting the server doesn't start falling down with error ORA-04030: out of process memory when trying to allocate 256 bytes (Heap0: KGL,kglob).

What gogolos, just checked:
oracle@server1 $ prctl -n project.max-shm-memory -i project default
project: 3: default
NAME PRIVILEGE VALUE FLAG ACTION RECIPIENT
project.max-shm-memory
privileged 31.4 GB — deny —
system 16.0 EB max deny

ROOT@server1 [UAT Active] /root# swap-l
swapfile dev swaplo blocks free
/dev/swap 0,0 16 76523504 76523504

ROOT@server1 [UAT Active] /root# prtconf |grep-i mem
prtconf:
Memory size: 131072 Megabytes

ROOT@server1 [UAT Active] /root# cat /etc/system
set noexec_user_stack=1
set noexec_user_stack_log=1


Limits checked:
server1 [UAT Active] /root# ulimit-H-a
time(seconds) unlimited
file(blocks) unlimited
data(kbytes) unlimited
stack(kbytes) unlimited
coredump(blocks) unlimited
nofiles(descriptors) 65536
vmemory(kbytes) unlimited


Could you tell me the path where to dig! Quite a stupor.
by | 19 views

6 Answers

0 like 0 dislike
To clarify. I will add here.
The problem is complicated by the fact that the server belongs to the British, and steer they give us it do not give. Send them commands — they execute — send the result.
by
0 like 0 dislike
ulimit under oracle
\r
[oracle]oracle@server1 $ ulimit -Ha
time(seconds) unlimited
file(blocks) unlimited
data(kbytes) unlimited
stack(kbytes) unlimited
coredump(blocks) unlimited
nofiles(descriptors) 65536
vmemory(kbytes) unlimited
by
0 like 0 dislike
Version: Oracle 11.1
by
0 like 0 dislike
Leave here the answer. Suddenly someone come in handy.
Everything works if you do not set the parameter
\r
DB_KEEP_CACHE_SIZE = 100M
by
0 like 0 dislike
Why — XS. Clearly a bug of Oracle.
by
0 like 0 dislike
I have the same error occurred. Try to reduce PGA_AGGREGATE_TARGET and/or increase the SWAP space.
by
110,608 questions
257,186 answers
0 comments
25,525 users