Glance Plus Help

[Laurie A. Krumrey]

Hi All,

I need some help in understanding what the
output from Glance Plus really means...
My DBA's think our server is having Memory
Problems. It has 2GB of Memory but in glance
the numbers don't add up. Is there a way to tell how much memory each processes is using?

Our server is consistently being maxed out at 100%. Before having my DBA's
decrease memory allocation for the Sybase & Oracle databases, is there a way
to break down what is using the 2GB of memory? Glance doesn't appear to show
what we need.


OUTPUT OF GLANCE:
==============================================
B3692A GlancePlus C.03.05.00 16:49:38 NAROPA 9000/800 Current Avg High
--------------------------------------------------------------------------------
CPU Util SA | 3% 3% 3%
Disk Util F FV | 11% 11% 11%
Mem Util S SU UB B | 86% 86% 86%
Swap Util U UR R | 65% 65% 65%
--------------------------------------------------------------------------------
PROCESS LIST Users= 1
User CPU Util Cum Disk Thd
Process Name PID PPID Pri Name ( 400% max) CPU IO Rate RSS Cnt
--------------------------------------------------------------------------------
glance 28638 28619 168 root 9.9/ 7.2 0.2 101/88.0 2.8mb 1
oracleastro 13171 1 154 oracle 0.0/ 0.0 12.6 0.0/ 0.0 28.5mb 1
ora_pmon_as 8163 1 156 oracle 0.0/ 0.0 16.2 0.0/ 0.0 36.8mb 1
oracleastro 25761 1 154 oracle 0.0/ 0.0 15.2 0.0/ 0.0 36.1mb 1
oracleastro 8549 1 154 oracle 0.0/ 0.0 0.9 0.0/ 0.0 28.3mb 1
oracleastro 19815 1 154 oracle 0.0/ 0.0 13.1 0.0/ 0.0 35.8mb 1
oracleastro 8853 1 154 oracle 0.0/ 0.2 44.1 0.0/ 0.2 35.9mb 1
oracleastro 19823 1 154 oracle 0.0/ 0.0 0.2 0.0/ 0.0 28.3mb 1
ora_smon_as 8171 1 156 oracle 0.0/ 0.0 2.9 0.0/ 0.0 35.8mb 1
ora_dbw0_as 8165 1 156 oracle 0.0/ 0.0 29.9 0.0/ 0.5 38.8mb 1
oracleastro 19811 1 154 oracle 0.0/ 0.1 144.2 0.0/ 0.0 36.8mb 1
RED ALERT Semaphore table is nearly full Page 1 of 3
ProcList CPU Rpt Mem Rpt Disk Rpt NextKeys

======

When I add up the RSS amounts they are over
100% CPU..How do I interrupt Glance? My
DBA's are using Glance and I need to explain
how it works...

THANK YOU,
Laurie

[James R. Ferguson · Accepted solution]

Hi Laurie:

Here's some information that may help:

Take a look at document #A4678152 ("Comparing page size for vmstat, top, glance, ps -el").

/begin_quote/

1. Top reports free memory in 1kb chunks so to get them to match you must divide tops free amount by 4 to get the true number of 4kb pages free and have it match vmstat. In other words, top reports in 1kb pages so these numbers must be multiplied by 4 to get 4kb kernel pages numbers.

2. For vmstat, avm (active virtual pages) and free (size of the free list) memory are reported in 4kb pages sizes.

3. Glance reports 1kb page sizes. This number will often be significantly different from ps -el since glance reports usage of shared memory also.

From the Glance help window for RSS (* PROC_MEM_RES): The number of KB of resident memory for the process. This consists of text, data, stack, as well as the process' portion of shared memory. This value is similar to the SZ field of the ps -el command, except that the ps command shows only data, stack, and text areas, and it reports their sizes in page units rather than KB. On some systems ps reports the virtual rather than
resident size.

4. ps -el reports in 4kb kernel page sizes.

/end_quote/

...JRF...

[James R. Ferguson]

Hi Laurie (again):

A very useful way to order processes memory is to do this (NOTE the absence of any semicolon after UNIX95= --> this keeps the variable set only for the invocation of the command line):

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

You (and your DBAs) might find that this helps your analyses.

Regards!

...JRF...