What do you say about this:
Run ps -efl|sort -k10,10 and you will get memory sorted by SZ (HP-UX). This is only login to baan process!

8.0.5:
3087 oraclebaan (LOCAL=NO)
1384 oracle8 (bsp:28045/PIPE) 28045 1

8.1.6:
1314 oracle8 (bsp:12676/PIPE) 12676 1
4264 oraclebaan4c4 (LOCAL=NO)

8.1.7:
1893 oracle8 (bsp:6882/PIPE) 6882 321
7930 oraclehpbaan (LOCAL=NO)

HP-UX = value x 4 = real value

So, as you see server-side process has been grown dramatically from 8.1.6. Is there anything you can do about this?
How about Oracle9?

Originally posted by makiju

Run ps -efl|sort -k10,10 and you will get memory sorted by SZ (HP-UX).

I tried the HP-UX command ps -ef but I get the following output:

$ ps -ef
UID PID PPID C STIME TTY TIME COMMAND
root 0 0 0 May 3 ? 0:37 swapper
root 1 0 0 May 3 ? 1:48 init
root 2 0 0 May 3 ? 23:58 vhand
root 3 0 0 May 3 ? 161:44 statdaemon


I suppose you mean ps -el

$ ps -el
F S UID PID PPID C PRI NI ADDR SZ WCHAN TTY TIME COMD
1003 S 0 0 0 0 128 20 6a4f58 0 - ? 0:10 swapper
141 S 0 1 0 0 168 20 101d3e600 100 400003ffffff0000 ? 0:00 init
1003 S 0 2 0 0 128 20 101b25f00 0 747e90 ? 0:00 vhand
1003 S 0 3 0 0 128 20 101b36200 0 5f2060 ? 0:00 statdaemon
1003 S 0 4 0 0 128 20 101b36500 0 6ec250 ? 0:00 unhashdaemon

I have found out that ps -command is not telling "the thruth"

But at least values can be compared by giving ps -efl | grep LOCAL
Look at column 10, SZ.

9-version gives values which are doubled amount of 8.1.7.

It is giving the the size in 1KB units of the core image of the process.

The core image can differ from the real size in memory.