Memory usage for DB and process

[Pando]

Dear Gurus,

I would like to ask what command to use to know how much memory is being used by a particular database and process it use in a test or production environment server. Thanks!

[A. Clay Stephenson]

By far, the best tool is Glance. You can also use:

UNIX95=1 ps -e -o comm,pid,vsz
combined with
ipcs -a

Bear in mind when trying to sum memeory usage that shared memory segments, shared library code, and shared text segments may be counted more than once, so getting an accurate, well-defined value is difficult.