Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re:memory question again ???

Re:memory question again ???

From: <dgoulet_at_vicr.com>
Date: Thu, 24 May 2001 11:26:03 -0700
Message-ID: <F001.0030DDFB.20010524112829@fatcity.com>

Janet,

    I'll try to show you with one of our larger Hp's:

VMSTAT takes a number of parameters, my favorite are:

Report memory status every 5 minutes for 5 reports. The AVM column gives available real memory. The FREE column indicates the amount of real and virtual memory that us available.

nbrahms:/ora1:02:vmstat 5 5

         procs           memory                   page                          
    faults       cpu
    r     b     w      avm    free   re   at    pi   po    fr   de    sr     in 
    sy    cs  us sy id
    1   170     0    21179  434071    5    1     0    0     0    0     0      0 
  1197   966  20  4 75
    1   172     0    22951  434041    7    1     0    0     0    0     0   1423 
  2848   607  15  2 83
    0   173     0    24727  434041    1    0     0    0     0    0     0   1111 
  2168   408  16  1 84
    1   172     0    22622  434041    0    0     0    0     0    0     0   1051 
  2091   306   5  1 94
    0   173     0    23773  434041    0    0     0    0     0    0     0    951 
  1486 226 11 1 88

VMSTAT -s (lower case) provides a dump of the internal registers that recods memory usage. In this case the MOST important parameter is "revolutions of the clock hand". For each revolution of the 'clock hand' you've gone through your entire swap file. Having a value > 0 is not necessarily bad depending on how long the server has been running. In this case the server has been running for 25 days.

nbrahms:/ora1:02:vmstat -s
0 swap ins
0 swap outs
0 pages swapped in
0 pages swapped out
48058981 total address trans. faults taken 13914835 page ins
0 page outs
20587 pages paged in
0 pages paged out
10013365 reclaims from free list
13911293 total page reclaims
44 intransit blocking page faults
36560237 zero fill pages created
23993691 zero fill page faults
6415045 executable fill pages created
20587 executable fill page faults
0 swap text pages found in free list
3607270 inode text pages found in free list 0 revolutions of the clock hand <-----**** 4750 pages scanned for page out
0 pages freed by the clock daemon
2146931554 cpu context switches
366656955 device interrupts
416856006 traps
2659952744 system calls

____________________Reply Separator____________________
Author: Janet Linsy <janetlinsy_at_yahoo.com>
Date:       5/24/2001 9:26 AM

Hi,

Thank you all for showing me how to check the Unix memory. Is there a way to show how much is used and how much is free?

Thank you!

Janet



Do You Yahoo!?
Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Janet Linsy
  INET: janetlinsy_at_yahoo.com
Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author:
  INET: dgoulet_at_vicr.com
Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Thu May 24 2001 - 13:26:03 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US