RE: Unix memory used

I guessed (emphasis on "guess") that you weren't using the memory you had because you originally showed your SGAs were very small. I looked at a Sun server that I run 2 databases on and the Total SGA for my training database was 35 MB, while my production was over 100Mb.

Another thing I said, that was very important is, was I assume that this is only a database server. If your application is running here too, then you have to consider the apps memory requirements too. If your machine is exclusively a database server, then you should be able to divide the memory for Oracle processes, Oracle User processes, and the OS.

Considering what I said, I recommend that you start your evaluation by tuning the memory of your databases because you don't know that you need more memory yet. You may be able to change some init.ora parameters and give yourself some huge performance gains. Management tends to like that! :-)

Good luck!

Michael Armstead
Database Administrator, OCP-Certified
Corporate & Finance Information Systems
Glaxo SmithKline

> -----Original Message-----
> From: Lanteigne, Mike [SMTP:MLanteigne_at_edc-see.ca]
> Sent: Wednesday, April 04, 2001 1:16 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Unix memory used
>
> Michael,
>
> Yes, that's what I want to do. In fact, I've pin pointed some areas, such
> as
> redolog buffers that can user larger memory segments. However I do not
> want
> to do this at the expense of the servers total memory use. That's why I'm
> wondering about the overall memory use (all databases and apps). Just out
> of
> curiosity, what makes you say I'm not using all the memory I have?
>
> Thanks
>
> Mike
>
> The views expressed here are mine and do not reflect the official position
> of my employer or the organization through which the internet was
> accessed.
>
>
> > -----Original Message-----
> > From: Armstead, Michael A [SMTP:maa25681_at_GlaxoWellcome.com]
> > Sent: Wednesday, April 04, 2001 11:35 AM
> > To: Multiple recipients of list ORACLE-L
> > Subject: RE: Unix memory used
> >
> > Just from looking at what you've described, you don't use the memory you
> > have on the machine. But I'm on the outside looking in. If your
> databases
> > are memory bound, my recommendation is to look into tuning your database
> > memory first, and expanding each SGA.
> >
> > I'm also assuming that this is only a database server.
> >
> > Michael Armstead
> > Database Administrator, OCP-Certified
> > Corporate & Finance Information Systems
> > Glaxo SmithKline
> >
> >
> > > -----Original Message-----
> > > From: Lanteigne, Mike [SMTP:MLanteigne_at_edc-see.ca]
> > > Sent: Wednesday, April 04, 2001 9:51 AM
> > > To: Multiple recipients of list ORACLE-L
> > > Subject: Unix memory used
> > >
> > > 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).
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Armstead, Michael A
> > INET: maa25681_at_GlaxoWellcome.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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Armstead, Michael A
  INET: maa25681_at_GlaxoWellcome.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).