Hi,

how do I find out how much memory Oracle uses on an HP-UX box?

Finding the shared memory portion (i.e. SGA) is fairly easy...

But how do I find out how much memory each dedicated user process is consuming?

Or is the rule of thumb like this: no matter whether you have 10 or 500 users, the memory consumed by the user processes will never exceed pg_aggregate_target?

This would mean that the maximum memory consumption is SGA + PGA_AGGREGATE_TARGET. No matter how many users are on the system (of course you would size PGA_aggregate_target accordingly beforehand).

This is 9.2 on HP-UX 11.

Thanks,
Helmut