memory usage

[Jay Cantwell]

is there a utility that I can run that tells me how much memory each process is utilizing??

I am on an 11.0 K system...and I am seeing a significant drop in RAM...I do not think it is memory leaking, because at the end of the day I get most of the memory back...

We are running ORacle 8.0.5 and 8.1.7 applications....

Glance is telling the user memory is 1.75 GB and that I have 190 MB free..

Any ideas...

thanks Jay

[James R. Ferguson · Accepted solution]

Hi Jay:

The following (thanks to Bill Hassell) uses the POSIX (UNIX95) options of the 'ps' command to assist in this tracking, and ranking the 'ps' output in descending kilobyte core size. A space character follows the 'UNIX95' variable declaration and the 'ps' command begins without any interceding delimiter. This sets UNIX95 only for the one command line.

# UNIX95= ps -e -o "user,vsz,pid,ppid,args" | sort -rnk2 | more

...JRF...

[paul courry]

Your running Oracle on 1.75Gb's?! Hmmmm........ Let me introduce you to my memory vendor.

[Deshpande Prashant]

HI
You can configure the /var/opt/perf/parm file at application level to catch the real time usage of memory by applications/processes.

eg. You can add following lines in param files.
application = ORACLE
file = ora_lgwr*, ora_smon*, ora_pmon*, ora_db*
user = oracle.

With this in glance menu go to applications (press "A" at glance menu) to see mem usage by application.
You can define application by user or process to get more details.

With measureware and perfview you can analyze to more depth of individual process and time.

Thanks.
Prashant Deshpande.

[Wodisch]

Hello Jay,

use "glance" or its GUI version "gpm", filter for the
oracle-processes, and have a look for the column "RSS"
(Resident Set Size = used RAM) and "VSS" (Virtual Set
Size = used SWAP space).
This should tell you all you want...
Oh, and make shure that your "dbc_max_pct" is set to
less than 10%, and you are using the "OnlineJFS" and
do have the mount-options "convosync=direct" and
"mincache=direct" in use, for that will save o LOT of ram,
and not allow the ram-wasting double-buffering you
would get else.

HTH,
Wodisch

[Jerry Zhang]

You can find RSS (Residence Memory Size) using

$ ps -elf |awk '{print $10}'

It will give RSS in pages (4MB per page).

[John Poff]

Jeff,

I've seen the Oracle middle tier software (web and forms servers) have some memory leaks before. In one case it was the wrbdm daemon. On my middle tier boxes I see the memory usage go up all day, and then drop off at 5pm when all the users go home.

JP