Unix memory used

From: Lanteigne, Mike <MLanteigne_at_edc-see.ca>
Date: Wed, 04 Apr 2001 06:54:35 -0700
Message-ID: <F001.002E10D7.20010404055111@fatcity.com>

        Hello list,

        We have a Sun e3500 with 4x300 MH processors, 1 GB Ram and OS 2.6. The server runs 4 small instances ( 7.3.4.5), two PeopleSoft apps and one more help desk app. As the below shows, or SGA's are very small (same for all 4 databases):

        SVRMGR> show sga
        Total System Global Area 6278336 bytes
        Fixed Size 39816 bytes
        Variable Size 4567352 bytes
        Database Buffers 1638400 bytes
        Redo Buffers 32768 bytes

        I'm looking for some ammunition to make a case to increase the RAM.

Yes, some database response is slow, however before I start tuning, especially memory sizes, I really think any efforts will be wasted if the memory is constantly thrashing to disk. I've been given access to top, and it reports the following:

        Memory: 1024M real, 15M free, 198M swap in use, 571M swap free (at 8:30 am on weekday)

        I guess I'm asking if I can say with validity that our memory is presently being used up, and the "198 MB swap in use" is a real number. Also, our SAs don't monitor memory use, so if anyone has any good tool, tricks, book references, etc...that I can use to see this kind of thing, I'd appreciated it.

        Thanks,

        Mike Lanteigne

The views expressed here are mine and do not reflect the official position my employer or the organization through which the internet was accessed.

--

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

Author: Lanteigne, Mike
  INET: MLanteigne_at_edc-see.ca

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 Apr 04 2001 - 08:54:35 CDT