RE: Unix memory used

Thanks Jared and Jacques and Dave and Michael,

I seem to remember a discussion on top a couple of years ago, that's why I was suspect about the numbers it was showing. I've been to the sun big admin page, lots there to read. I'll track down some of the other suggested sites, as well as look for that book.

Thanks again

Mike Lanteigne

> -----Original Message-----
> From: jkstill_at_cybcon.com [SMTP:jkstill_at_cybcon.com]
> Sent: Wednesday, April 04, 2001 9:16 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: Unix memory used
>
>
> Mike,
>
> The amount of memory available as shown by 'top' is
> of little use, as Solaris gobbles up nearly all of it
> leaving little free, regardless of how much you have.
>
> Use vmstat to determine the paging rate. I can't think
> of a good number at the moment, and my Solaris books are
> currently packed away.
>
> You also want to check the page scan rate ( I think that's
> the right term ). It is tunable, and will take up a lot
> of CPU if set incorrectly.
>
> If there is *any* swapping taking place, it is too much
> and you need more memory, barring problems such as
> memory leaks.
>
> The Solaris book by Adrian Cockroft is a must have if
> you are doing any tuning work on Solaris. It will explain
> clearly everything I have alluded to here.
>
> Jim Munro's book is a must have if you want info on
> Solaris internals.
>
> Jared
>
> On Wed, 4 Apr 2001, Lanteigne, Mike wrote:
>
> > 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).
> >
>
>
> Jared Still
> jkstill_at_cybcon.com
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author:
> INET: jkstill_at_cybcon.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: 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).