Can you tell me whcih patch to solve the memory leak problem ?

[xiongye_2]

Hi: all
I have one oracle test enviorment that run on hp-ux 11.00 platform.
When I execute some operation like delete million rows from one table ,
the free memory of OS reduce qucikly.
But when the operation finished, the memory occupied by the delete process not return to OS.
I think maybe some patch related to process memory leak that I have not install.
Some one told me that I need install patch phss_23655 .
Can you tell me some other patch must installed on hp-ux 11.00 ? Thanks !!

[Armin Feller]

download this ones, check dependencies and install them with option match_target

PHKL_22208 Fix VxFS DMAPI DPFs and Memory Leak
PHKL_23409 [O] NFS, Large Data Space, kernel memory leak
PHKL_24082 VxFS 3.3 Fix DMAPI memory leak & NFS hang
PHNE_25579 HSC 100BT lan cumulative patch
PHNE_25580 PCI 100BT lan cumulative patch
PHNE_25907 Built-in PCI 100BASE-T patch
PHNE_26096 [O] telnet kernel and telnetd(1M) patch
PHNE_26250 LAN product cumulative patch
PHNE_26271 4 port PCI 100BASE-T cumulative patch
PHNE_26293 PCI 100B(Tx/Fx) cumulative patch
PHNE_26297 [O] 3.10.01 ACC X.25/9000 Link S/W Patch
PHNE_26730 ATM PCI, HSC and HP-PB cumulative patch
PHCO_26916 more(1) cumulative patch
PHSS_26943 Support Tool Manager Dec 01 Patch
PHNE_27651 [O] Cumulative STREAMS Patch
PHNE_27821 Streams Pty cumulative patch
PHNE_27886 [WB] cumulative ARPA Transport patch
PHNE_28102 [O] ONC/NFS General Release/Performance Patch
PHKL_28131 SCSI IO Subsystem Cumulative Patch
PHKL_28172 kmadmin; autoload; DLKM load; MO; eventport
PHKL_28502 diag2 cumulative patch
PHKL_28602 VxFS fsadm,MMF hang,mmap() perf improvement
PHSS_28613 [O] Support Tool Manager Mar 02 Patch

[Michael Steele_2]

Very, very often when "...process not return to OS..." this is because the process has become a runaway. Can you stop oracle?

Try fuser /filesystem

-or-

ps -ef | grep -i ora

-or-

lsof /filesystem

...and analyze.

[Rita C Workman]

It has been my experience that the best resolution to a memory leak problem...has been to find the process, and fix it's code.

Just a thought,
Rita