System Administration
cancel
Showing results for 
Search instead for 
Did you mean: 

explanation of sar -v 1 10 output

 
NDO
Super Advisor

explanation of sar -v 1 10 output

Hi All

 

Please can someone explain if the output :

 #sar -v 1 10

HP-UX dbnode0 B.11.31 U ia64    05/04/14

22:04:14 text-sz  ov  proc-sz  ov  inod-sz  ov  file-sz  ov
22:04:15   N/A   N/A 417/30000 0  2005/736048 0  3094/2147483647 0
22:04:16   N/A   N/A 417/30000 0  2005/736048 0  3094/2147483647 0
22:04:17   N/A   N/A 419/30000 0  2007/736048 0  3112/2147483647 0
22:04:18   N/A   N/A 423/30000 0  2011/736048 0  3133/2147483647 0
22:04:19   N/A   N/A 421/30000 0  2009/736048 0  3130/2147483647 0
22:04:20   N/A   N/A 423/30000 0  2011/736048 0  3148/2147483647 0
22:04:21   N/A   N/A 422/30000 0  2010/736048 0  3140/2147483647 0
22:04:22   N/A   N/A 424/30000 0  2012/736048 0  3158/2147483647 0
22:04:23   N/A   N/A 424/30000 0  2012/736048 0  3158/2147483647 0
22:04:24   N/A   N/A 425/30000 0  2013/736048 0  3166/2147483647 0

 can indicate memory issues?

 

By using glance -m I see 88% utilization,

5 REPLIES

Re: explanation of sar -v 1 10 output

>can indicate memory issues?

 

There are no issues with these tables.  While they are growing, they are way under their limits.

What's your real problem?

NDO
Super Advisor

Re: explanation of sar -v 1 10 output

Hi

 

My memory consumption is very high:

 

 Glance C.05.00.000             07:50:07  dbnode0     ia64                                                                          Current  Avg  High
------------------------------------------------------------------------------------------------------------------------------------------------------
CPU  Util   S         SU               U                                                                                             | 23%   23%   29%
Disk Util   F                                                                                                      F                 | 87%   16%   87%
Mem  Util   S                             SU                                                UF                           F           | 93%   93%   94%
Networkil   U                                              UR                      R                                                 | 59%   60%   62%
------------------------------------------------------------------------------------------------------------------------------------------------------
                                                                    MEMORY REPORT                                                         Users=    2
Event         Current   Cumulative   Current Rate   **bleep** Rate   High Rate
--------------------------------------------------------------------------------
Page Faults      8085       275047      1554.8     1057.8      2520.9
Page In             0          135         0.0        0.5      1356.6
Page Out            0            0         0.0        0.0         0.0
KB Paged In       0kb        540kb         0.0        2.0       725.2
KB Paged Out      0kb          0kb         0.0        0.0         0.0
Reactivations       0            0         0.0        0.0         0.0
Deactivations       0            0         0.0        0.0         0.0
KB Deactivated    0kb          0kb         0.0        0.0         0.0
VM Reads            0           11         0.0        0.0         1.3
VM Writes           0            0         0.0        0.0         0.0
Total VM :  19.5gb   Sys Mem  :   8.3gb   User Mem:  13.4gb   Phys Mem :  31.9gb
Active VM:  13.1gb   Buf Cache:     0mb   Free Mem:   2.3gb   FileCache:   7.8gb
MemFS Blk Cnt:                0   MemFS Swp Cnt:                0

 from the command line:

 

 #UNIX95=1 ps -e -o vsz,pid,ppid,args | sort -rn | head -20
 172544  3496     1 ora_mmon_bscsprod0
 172288  3011     1 ora_mmon_bscsrtx0
 172224 23019     1 ora_p011_bscsprod0
 172224 23017     1 ora_p010_bscsprod0
 172224 23010     1 ora_p009_bscsprod0
 172224 23008     1 ora_p008_bscsprod0
 172224  3498     1 ora_mmnl_bscsprod0
 172224  3333     1 ora_p000_bscsprod0
 172224  3013     1 ora_mmnl_bscsrtx0
 172160  3469     1 ora_arc1_bscsprod0
 172160  3344     1 ora_p004_bscsprod0
 172160  3342     1 ora_p003_bscsprod0
 172160  3338     1 ora_p002_bscsprod0
 172160  3336     1 ora_p001_bscsprod0
 172160  2990     1 ora_arc1_bscsrtx0
 172096  3483     1 ora_qmnc_bscsprod0
 172096  3467     1 ora_arc0_bscsprod0
 172096  3293     1 ora_lck0_bscsprod0
 172096  3218     1 ora_dbw0_bscsprod0
 172096  3187     1 ora_lmon_bscsprod0

 and I saw on ths forums, someone suggesting that for thica cases, we should also check the tables created by vx_ninode..

NDO
Super Advisor

Re: explanation of sar -v 1 10 output

does the following output of "ipcs" command, indicates any problems with memory:

 

 ipcs -bmop
IPC status from /dev/kmem as of Mon May  5 09:50:12 2014
T         ID     KEY        MODE        OWNER     GROUP NATTCH      SEGSZ  CPID  LPID
Shared Memory:
m          0 0x554c0197 --rw-r--r--      root      root      1     120064   440   440
m          1 0x415c449f --rw-rw-rw-      root      root      0        348  1224 10421
m          2 0x4e4c0002 --rw-rw-rw-      root      root      2      61760  1224  2517
m          3 0x4160be4f --rw-rw-rw-      root      root      2       8192  1224 10421
m          4 0x00a5c581 --rw-------     sfmdb     users      1   10469376  2319  2322
m          5 0x415c0d95 --rw-------      root      root      1       4096  2637  4504
m   22773766 0x53d435b8 --rw-r-----    oracle  oinstall    166 8593362944 19923 27763
m          7 0x06347849 --rw-rw-rw-      root      root      2      65544  3640 16337
m          8 0x0c6629c9 --rw-r-----      root      root      5  199173784  3717 26011
m          9 0x5e606027 --rw-------      root      root      1        512  3332  3332
m         10 0x4954e79d --rw-r--r--      root      root      0      22912  3708  3838
m         11 0x01608640 --rw-rw-r--      root      root      1       4192  3762  3762
m      32780 0x016088ce --rw-rw-r--      root      root      1       4192  4040  4040
m         13 0x01608646 --rw-rw-r--      root      root      1       4192  3818  3818
m         14 0x016000dc --rw-rw-r--      root      root      1       4192  3875  3875
m         15 0xa94c006b -----------      root      root      1          1  4362  4363
m    4259856 0x44883d40 --rw-r-----    oracle  oinstall     89 6445871104 20629 23453

 

Re: explanation of sar -v 1 10 output

>My memory consumption is very high:

 

This is a good thing.  Are you having problems starting new processes?

You have no page outs.

 

>does the following output of ipcs command, indicates any problems with memory:

 

It just says that Oracle has some shared memory:  8.5 and 6.5 GB.

NDO
Super Advisor

Re: explanation of sar -v 1 10 output

hi

 

what happened was that an coleague was trying to acess the DB of this server, from another hp-ux server, and she was having shared memory errors, and trhown out of the application.

So we rebooted the DB server, (306 days uptime), and memory consumption was brought down to 70% seen in glance, and she can now acess the DB