-
Error ORA-04030: out of process memory
When i am running a sql file againt one database I am getting the following error .
ORA-20001: Update statement.:ORA-04030: out of process memory when trying to
allocate 475276 bytes (callheap,DARWIN)
Could anybody help me How to fix this error.
Thanks in advance
-
Is your shared pool large enough?
You could be a hitting a bug that was fixed in 8.1.7.3.
David Knight
OCP DBA 8i, 9i, 10g
-
Is this happening in 8i or 9i?
-
RDBMS version is 8i
and
shared_pool_reserved_size 30000000
shared_pool_size 700000000
-
Or you can try
if this is a unix machine and you are using a telnet session do
$ ulimit -d unlimited
$ ulimit -s unlimited
$ ulimit -m unlimited
$ ulimit -n unlimited
$ ulimit -c unlimited
and then try....
HTH
Amar
Amar
"There is a difference between knowing the path and walking the path."
-
Found that the following event has been set.
event = "10235 trace name context forever, level 1"
Is this causing the problem ?
-
Originally posted by ganjisb
Found that the following event has been set.
event = "10235 trace name context forever, level 1"
Is this causing the problem ?
This event will check the memory manager internal structures. and generates trace in the UDUMP.
This can be a possible cause as this degrades the performance.
According to metalink
-------------------------------------------------------
This event may be used to try to catch HEAP corruption problems closer to when they occur. Typically level 12 is required to get close to the corruption but this can impact performance too much to be useful.
-------------------------------------------------------
Try removing this parameter and then startup the database and run the querry again.
Regards
Amar
Amar
"There is a difference between knowing the path and walking the path."
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|