ORA-04030 When Clients Connect Across Network Using SQL*Net
Last updated on APRIL 30, 2013
Applies to:Oracle Database - Enterprise Edition - Version 10.2.0.4 and later
Information in this document applies to any platform.
You may see the one or more of the following scenarios:
- Alert log shows error ORA-04030 when connecting remotely using SQL*Net:
ORA-04030: out of process memory when trying to allocate 258072 bytes (QERGH hash-agg,kllcqas:kllsltba)
- Local connection works without any errors and user process is using about 142 MB of PGA for the session.
- Increased the parameter pga_aggregate_target to 5G or more but the error still occurs:
ALTER SYSTEM SET pga_aggregate_target='5000M' SCOPE=SPFILE SID='*';
- A heapdump shows a user process is using about 100M of PGA for the session when connecting via SQL*NET which is less than the memory used during local connection.
event= '4030 trace name heapdump level 536870917;name errorstack level 3'
The following unix/linux OS limits are set to unlimited:
The following unix/linux OS parameters are also set in the file /etc/security/limits for Oracle user and OS user but problem still occurs:
fsize = -1
core = -1
cpu = -1
data = =-1
stack = -1
rss = -1
nofiles = -1
but problems still persist.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms