topic Re: memory usage in Operating System - HP-UX

memory usage

Jay Cantwell — Mon, 06 Aug 2001 18:36:15 GMT

is there a utility that I can run that tells me how much memory each process is utilizing??

I am on an 11.0 K system...and I am seeing a significant drop in RAM...I do not think it is memory leaking, because at the end of the day I get most of the memory back...

We are running ORacle 8.0.5 and 8.1.7 applications....

Glance is telling the user memory is 1.75 GB and that I have 190 MB free..

Any ideas...

thanks Jay

Re: memory usage

James R. Ferguson — Mon, 06 Aug 2001 18:42:28 GMT

Hi Jay:

The following (thanks to Bill Hassell) uses the POSIX (UNIX95) options of the 'ps' command to assist in this tracking, and ranking the 'ps' output in descending kilobyte core size. A space character follows the 'UNIX95' variable declaration and the 'ps' command begins without any interceding delimiter. This sets UNIX95 only for the one command line.

# UNIX95= ps -e -o "user,vsz,pid,ppid,args" | sort -rnk2 | more

...JRF...

Re: memory usage

paul courry — Mon, 06 Aug 2001 18:45:06 GMT

Your running Oracle on 1.75Gb's?! Hmmmm........ Let me introduce you to my memory vendor.

Re: memory usage

Deshpande Prashant — Mon, 06 Aug 2001 18:55:27 GMT

HI
You can configure the /var/opt/perf/parm file at application level to catch the real time usage of memory by applications/processes.

eg. You can add following lines in param files.
application = ORACLE
file = ora_lgwr*, ora_smon*, ora_pmon*, ora_db*
user = oracle.

With this in glance menu go to applications (press "A" at glance menu) to see mem usage by application.
You can define application by user or process to get more details.

With measureware and perfview you can analyze to more depth of individual process and time.

Thanks.
Prashant Deshpande.

Re: memory usage

Wodisch — Tue, 07 Aug 2001 17:26:12 GMT

Hello Jay,

use "glance" or its GUI version "gpm", filter for the
oracle-processes, and have a look for the column "RSS"
(Resident Set Size = used RAM) and "VSS" (Virtual Set
Size = used SWAP space).
This should tell you all you want...
Oh, and make shure that your "dbc_max_pct" is set to
less than 10%, and you are using the "OnlineJFS" and
do have the mount-options "convosync=direct" and
"mincache=direct" in use, for that will save o LOT of ram,
and not allow the ram-wasting double-buffering you
would get else.

HTH,
Wodisch

Re: memory usage

Jerry Zhang — Tue, 07 Aug 2001 18:24:38 GMT

You can find RSS (Residence Memory Size) using

$ ps -elf |awk '{print $10}'

It will give RSS in pages (4MB per page).

Re: memory usage

John Poff — Tue, 07 Aug 2001 18:36:41 GMT

Jeff,

I've seen the Oracle middle tier software (web and forms servers) have some memory leaks before. In one case it was the wrbdm daemon. On my middle tier boxes I see the memory usage go up all day, and then drop off at 5pm when all the users go home.

JP