Home » Infrastructure » Unix » Issue with the Memory (Oracle,9.2.0.5.0,SunOS 5.9)
Issue with the Memory [message #469394] Wed, 04 August 2010 08:14 Go to next message
sathik
Messages: 196
Registered: August 2009
Location: INDIA
Senior Member
Hi,
We are seeing the memory issues when we run certain application proceses. Can you please check the exceptions as why they have been encountered. How we can avoid this?


ORA-04030: out of process memory when trying to allocate 8216 bytes (koh-kghu sessi,static frame of inst)
ORA-04030: out of process memory when trying to allocate 16408 bytes (koh-kghu call ,pmuccst: adt/record)
04030. 00000 - "out of process memory when trying to allocate %s bytes (%s,%s)"
*Cause: Operating system process private memory has been exhausted


Note:

/usr/sbin/prtconf |grep -i mem
Memory size: 32768 Megabytes
memory (driver not attached)
virtual-memory (driver not attached)
memory-controller, instance #0
memory-controller, instance #1
memory-controller, instance #2
memory-controller, instance #3


SQL> select * from v$sga;

NAME VALUE
-------------------- ----------
Fixed Size 749688
Variable Size 6442450944
Database Buffers 6442450944
Redo Buffers 2383872

[Updated on: Wed, 04 August 2010 08:20]

Report message to a moderator

Re: Issue with the Memory [message #469405 is a reply to message #469394] Wed, 04 August 2010 08:26 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
It is not GLOBAL memory but PROCESS private one.
This one is limited by "ulimit" values.

Regards
Michel
Re: Issue with the Memory [message #469410 is a reply to message #469405] Wed, 04 August 2010 09:00 Go to previous messageGo to next message
sathik
Messages: 196
Registered: August 2009
Location: INDIA
Senior Member

ULIMIT values are given below.

$ulimit -a
time(seconds) unlimited
file(blocks) unlimited
data(kbytes) unlimited
stack(kbytes) 8192
coredump(blocks) unlimited
nofiles(descriptors) 10000
vmemory(kbytes) unlimited

Now what I need to change in this? And what are checks I need to do to define the value.
Re: Issue with the Memory [message #469411 is a reply to message #469410] Wed, 04 August 2010 09:13 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
"stack"
Ask your system administrator.

Regards
Michel

[Updated on: Wed, 04 August 2010 09:13]

Report message to a moderator

Re: Issue with the Memory [message #470835 is a reply to message #469411] Wed, 11 August 2010 01:33 Go to previous messageGo to next message
sathik
Messages: 196
Registered: August 2009
Location: INDIA
Senior Member
There is no system admin for my environment.So I am only the responsible for that also.

So can you please help me to resolve the issue.

I undersand, The ORA-4030 error is occured due to the following reasons.

1.when an Oracle process requests additional memory from the OS, but the OS cannot find enough free memory from the PGA to allocate. This can occur if OS does not have enough physical memory or swap space available for the process.
2.The OS is configured to limit the amount of memory available for the processes.
3.An Oracle bug has been encountered.

I can able to understand the 1st reason.But the project is not ready to add the RAM.And they are asking to tune the process only.

Regarding the 2nd reason,how can I find is there any limit has been set from the OS level regarding PGA? Since we are having problem with the PGA. And what I need check in that to understand about the issue?

[Updated on: Wed, 11 August 2010 01:42]

Report message to a moderator

Re: Issue with the Memory [message #470838 is a reply to message #470835] Wed, 11 August 2010 01:41 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
1. Oracle ask memory to the OS (malloc), there is no more memory available due to OS limit for the process, Oracle gets an error code from the OS

2. Yes, this is the case. I don't know how to see it but with "ulimit" and I don't know how to modify it, I am not a sysadmin, have a look at your OS documentation or post the question in a SunOs forum.

3. It is not the case here.

Regards
Michel
Previous Topic: Problem in FTP script with lcd command
Next Topic: Performance issue in reading file in unix
Goto Forum:
  


Current Time: Thu Mar 28 13:15:58 CDT 2024