memory leakes from oracle client libraries on hpux 11i

[Shivkumar]

Hi,

We suspect that there are memory leakage from some oracle 9.2.x.x client libraries runnning on hpux 11i vi.
Can someone suggest some commands of hpux or tools to identify which libraries are producing the memory leaks ?

Thanks,
Shiv

[Ken Grabowski]

Glance will allow you to monitor processes including the memory they are using.

[Bill Hassell · Accepted solution]

A memory leak is a simply unwanted or unexpected growth of a program's data area. The key is "unwanted/unexpected". If true, then it is a symptom of bad programming. However, it is quite normal for many programs to grow in size because that is required. You can monitor the largest programs for memory growth by sorting the processes by size:

UNIX95=1 ps -e -o vsz,pid,ppid,args | sort -rn | head -20

Just run this on a regular basis to monitor the largest processes. Now memory usage in Unix is complex and the processes may not be growing but shared memory may be growing. ipcs -bmop will monitor this, but it will be difficult to find which process is growing the segment. And be sure your buffer cache is reasonable (no more than 800 to 1500 megs).

[Shivkumar]

Bill, Could you please explain the statement in great detail "Now memory usage
in Unix is complex and the processes may not be growing but shared memory may be growing"

Apreciate help from any Unix Guru of the forum.

Thanks,
Shiv

[RAC_1]

The memory management on HP-UX is complex as it is a virtual memeory, shared memory, stack, text and data. All these are inerrelated. So when bill said, the shared ememory usage might be going up, a processes might not be increasing it's text, or stack but might be growing in shared memory and finding which processes is how much shared memory a little difficult.

There is shminfo toll that may help you. Also if you monitor shared memory usage with ipcs -m, and you see over a period of time the usage is going up, you need to start at looking which user is using it and associate it with pid and troubleshoot it further.

[Arunvijai_4]

Hi Shiv,

Finding out memory leak is not an easy task, sometimes you may be fooled around by memory. If you are good in debugging, you can find out memory leak with GDB. Otherwise, better log a call with Oracle Support, they might help you.

BTW, Have you checked the latest patches available for Oracle as well as HP-UX ?

-Arun

[Bill Hassell]

Shared memory is a technique that programmers use to allow multiple programs to share information at memory speeds. The main program requests a shared memory segment, then communicates the segment ID to certain programs that will use this same area. In Oracle, this is called SGA and Oracle programs will will allocate the area as required. That is not a memory leak, it is the design of the program. If you are trying to run Oracle in just a couple of Gb of RAM, you will have a lot of problems with performance.

[Steven E. Protter]

Shalom Shivkumar,

I find memory leaks by watching a process either with glance or a UNIX95 ps command.

It the amount of memory for a process continues to grow over time, its a suspect.

These problems are sometimes solved with Operating System patches, but more often with patches to the application.

SEP

[Arunvijai_4]

Hi Shiv,

A very white good paper,
http://docs.hp.com/en/1218/mem_mgt.html

-Arun

[Shivkumar]

Is someone aware of any 3rd party tools used to detect memory leaks on HPUX platform from OS and different kind of applications running on it ?

Regards,
Shiv