Strange report from 'vmstat'

From: Sonja ©ehoviæ <sonja.sehovic_at_pbz.hr>
Date: Wed, 02 May 2001 07:53:06 -0700
Message-ID: <F001.002F71A7.20010502061930@fatcity.com>

Hi all!
Oracle 8.1.7 on AIX (8GB RAM (+ swap space 9GB)). It concerns AIX memory 'problem'. When I issue vmstat command, we got following result:

/u01/app/oracle/product/8.1.7.>vmstat 2 4 kthr memory page faults cpu

----- ----------- ------------------------ ------------ -----------

r b avm fre re pi po fr sr cy in sy cs us sy id wa 0 0 580556 554 0 0 0 14 34 0 126 137 63 11 5 82 1 0 2 580556 549 0 0 0 0 0 0 708 527 206 0 0 99 0 0 2 580557 548 0 0 0 0 0 0 829 99854 421 2 10 88 0 0 2 580557 548 0 0 0 0 0 0 637 111 35 0 0 99 0

Analysing this output, it seams that we have cca 2GB RAM (example: (580557 + 548)* 4096 = 2,2 GB), while we expected min 8GB. This gap between 8GB and output from vmstat report, increases in time. The question is if our calculation was right, is this the right way to analyse this at all?
Maybe it is important to say, that our Oracle is installed on OFA using data files, max size 2GB, in same volume group(not on raw devices). Do you know of any AIX memory problems which can manifests as mentioned above?

TIA,
Sonja

--

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

Author: =?iso-8859-2?Q?Sonja_=A9ehovi=E6?= INET: sonja.sehovic_at_pbz.hr

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 Wed May 02 2001 - 09:53:06 CDT