get physical and virtual memory

tads98 · July 26, 2005, 4:06am

What command can i use to get the physical and virtual memory of a database?

jim_mcnamara · July 26, 2005, 10:13am

Can you give us a little more information: database and OS?

tads98 · July 28, 2005, 10:06pm

we are running an HP-UX Unix Server...

zazzybob · July 29, 2005, 7:52am

As Jim has asked, please let us know which database you're using too.

Cheers
ZB

tads98 · July 31, 2005, 10:25pm

Sorry, we are running an Oracle Database in a UNIX Server. Thanks for the help.

nir_s · August 1, 2005, 2:46am

Hi tads98,

Issue the command "top" and you can see there the Physical and the virtual memory.
e.g:

Memory: 217020K (175408K) real, 562684K (507512K) virtual, 1010356K free  Page# 1/11

The pysical memory in our example is "real" :
Total - 217020K
Free - 175408K

The virtual memory is "virtual" :
Total - 562684K
Free - 507512K

Regards,
Nir

jim_mcnamara · August 1, 2005, 11:07am

Oracle also creates a slew of processes on the box where the user processes reside -
in any case also try glance.

tonanbe · August 5, 2005, 3:00am

System utilities such as 'ps' or 'top' are not relevant.
Some operating systems provide better tools for mesuring process size ; for example Solaris has /usr/proc/bin/pmap
have a look to commands like vmstat and memstat and particulary to oracle note 174555.1 "determining the size of an oracle process."
Hope that this will help
Tonanbe