Home » RDBMS Server » Server Administration » out of process memory
out of process memory [message #345032] Tue, 02 September 2008 03:12 Go to next message
srini_thiru
Messages: 133
Registered: May 2008
Senior Member


Hi Everybody,

In one of our production database we receive ORA-04030 out of process memory when we try to run a report.

When i checked the alert logfile i found the below error occurred continuosly.

skgpspawn failed:category = 27143, depinfo = 9261, op = spdcr, loc = skgpspawn


Database Details

Oracle Version 9.2.0.5.0
server Windows 2003 server
Ram 3.75GB
Virtual memory 2GB

Init parameters details:

shared_pool_size= 192M
sga_max_size=1440M
pga_aggregate_target=1440M
shared_servers=0
max_shared_Servers=20


Please anyone guide me to fix this issue.


Re: out of process memory [message #345036 is a reply to message #345032] Tue, 02 September 2008 03:17 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
ORA-04030: out of process memory when trying to allocate %s bytes (%s,%s)
 *Cause:  Operating system process private memory has been exhausted
 *Action:

Check ulimit and try to enlarge the available memory for each process (at OS level, not Oracle one).

Regards
Michel
Re: out of process memory [message #345047 is a reply to message #345036] Tue, 02 September 2008 03:46 Go to previous messageGo to next message
srini_thiru
Messages: 133
Registered: May 2008
Senior Member

Can you please tell me how to enlarge the ulimit parameter in windows 2003 server.

With thanks,
Seenu
Re: out of process memory [message #345050 is a reply to message #345047] Tue, 02 September 2008 03:49 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I don't know, sorry, didn't see you are on Windows.

Regards
Michel
Re: out of process memory [message #345054 is a reply to message #345032] Tue, 02 September 2008 03:55 Go to previous messageGo to next message
alanm
Messages: 282
Registered: March 2005
Senior Member

hi,
Is this a 32 bit OS?

there are a number of switches that have to be configured for windows

/3GB, /PAE, /USERVA

other things to look at are

USE_DIRECT_BUFFERS


regards

Alan

[Updated on: Tue, 02 September 2008 04:15]

Report message to a moderator

Re: out of process memory [message #345058 is a reply to message #345054] Tue, 02 September 2008 04:04 Go to previous message
srini_thiru
Messages: 133
Registered: May 2008
Senior Member
thank u Michel,

Alan,

Yes this is for 32 bit.

And virtual memory has been set to 2GB

Size of the RAM is 3.75GB

With Thanks,
Seenu
Previous Topic: Reconciling SGA_MAX_SIZE with other components
Next Topic: Error while running dbms_repair
Goto Forum:
  


Current Time: Wed Dec 07 18:40:35 CST 2016

Total time taken to generate the page: 0.12538 seconds