topic Re: Oracle Memory Hogs in Operating System - HP-UX

Oracle Memory Hogs

Seth Patterson — Wed, 26 Sep 2001 20:02:43 GMT

I have a V2500 running 11.0. It has 14 processors and 12gb of memory. It is the database server for our Website. The front end application/web servers are NT machines that attatch to the DB server using an Oracle JDBC driver.
The dedicated server processes that are spawned through the JDBC connection usually use about 2-5mb of RSS. However, over time, some of them will go as high as 200mb! The process ID will change, but it is like the memory is never freed up back to the OS for redistribution. Is it possible that the socket connection retains the memory and each new Oracle process that comes through the pipe is reusing the already allocated RSS?? It eventaully brings the system to its knees. Oracle recommends upgrading the JDBC client but can't give me a reason as to why that will fix the issue.

Any ideas would be great! Thanks!

Re: Oracle Memory Hogs

Wodisch — Thu, 27 Sep 2001 17:31:02 GMT

Hello Seth,

have a look at hp's Java pages at

http://www.hp.com/go/java

there were a lot of improvements for Java
running under HP-UX 11.x this year!

HTH,
Wodisch

Re: Oracle Memory Hogs

Sanjay_6 — Thu, 27 Sep 2001 18:02:15 GMT

Hi Seth,

this sound like an application related issue. An upgrade of your JDBC driver might help.

thanks

Re: Oracle Memory Hogs

Santosh Nair_1 — Thu, 27 Sep 2001 18:12:03 GMT

Seth,

I second Sanjay's sentiment, it does sound application related. Also, once a process has gone away, it should release all the memory that it had back to the OS for distribution amongst the other processes.

-Santosh