Originally posted by: SystemAdmin

Hi Friends,

We have an Oracle database runing on AIX server. How can we find out how much memory by Oracle from nmon's output?

Thank you in advanced for your insights.

• SS

#AIX-Forum

Originally posted by: SystemAdmin

or Unix command to find out how much memory is being used by Oracle processes.

Thanks for the help.

SS ~
#AIX-Forum

Originally posted by: hdkutz

Hello,
use

1. svmon -U <YOUR_ORACLE_USER>

svmon command shows how much Memory is consumed by a user.

If using nmon, type t and then sort the Process Display to size by typing 4.
You should see now the Processes which consume most memory.
or

1. svmon -Put 10 # top 10 users of memory
2. svmon -Pgt 10 # top 10 users or paging space

or
ps av |head -1;ps av |sort +5 -r |head -n 5|grep -v PID

Cheers,
ku
#AIX-Forum