Memory consumption on HP-UX

[HDaiminger]

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

[deepakc_in]

When PGA_AGGREGATE_TARGET parameter is set oracle 9i will ignore all of the PGA parameters in the init.ora, including all parameter like sort%.
Once the pga_aggregate_target has been set oracle will automatically manage PGA memeory allocation, based upon the individual needs
It can be dynamically changed by alter system command.

There are some workarea_% parametee which can be used in conjuction with the pga_aggregate_target.

Total Unix Ram=fixed sga+ pga + ram reserved for OS