Hi Guys,
I wonder what would be the best way to determine how much memory is in use on any given time by the database processes. I thought about using ipcs -m command but I wonder if there any better way to determine this. Thanks.
Harby.
Hi Guys,
I wonder what would be the best way to determine how much memory is in use on any given time by the database processes. I thought about using ipcs -m command but I wonder if there any better way to determine this. Thanks.
Harby.
There are two "types" of memory a database process can hold: shared memory and process memory. The amount of shared memory the process holds you can find out with the ipcs utility as you already found out.
For the memory dedicated to the process you will have to use the "ps" command. A good starting point would be "ps -Alo vsz". Have a look at the "-o" option of "ps" to understand the command and how to tailor it to your needs.
I hope this helps.
bakunin
hi ,
If i use the ps v 1818740 command I get the below output:
PID TTY STAT TIME PGIN SIZE RSS LIM TSIZ TRS %CPU %MEM COMMAND
1818740 - A 0:00 60 1976 1064 xx 39 112 0.0 0.0 db2sysc
what is the best column that i should use to summarize how much memory is in use the RSS or the SIZE column. Thanks .
Harby.