Query V$SGA. Unless you are running Oracle9i, there are no memory leaks in
the SGA, because all allocation of memory for the SGA (prior to Oracle9i)
occurs at instance startup and then at no other time. Just as in crime
investigations, you must have "MO": "motive" and "opportunity". No
"opportunity", no crime. In Oracle9i, the "opportunity" does exist because
there is functionality to grow and shrink components of the SGA, all under
DBA control only. But now, even with "opportunity" in place, you'll have to
establish "motive"... :-)
For the other components of Oracle-managed memory, there is the PGA (process
global area) and the UGA (session/user global area). Query statistics with
the phrases "pga" and "uga" in their name from V$SESSTAT for information
about the current memory consumption situation in those areas.
---
Consider also using OS utilities to determine which processes are consuming
more and more virtual memory. Remember that the shared SGA will be
"counted" as part of the virtual memory image of every Oracle server
process, even though it exists in reality only once, so you have to correct
for that yourself. If you are running Solaris, the "pmap -x <os-pid>"
utility provides a terrific breakdown of process images into text,
heap/data, and stack; on AIX, the best utility for the same purpose is
"svmon". I don't know about the other UNIX flavors...
If you're on Solaris, you can download "oramem.sh" from
http://www.EvDBT.com/tools.htm (script located near the bottom of the page)
to summarize detailed virtual memory information on a specific Oracle
instance's server processes from "pmap -x". If you're running on another
variant of UNIX, then this script might serve as a potential starting point
for rewrite using the memory mapping utility there.
If you're on Windows, perhaps someone else on the list can help?
----- Original Message -----
To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
Sent: Monday, September 02, 2002 2:08 AM
> How will you check Memory leakage in the SGA and how to rectify it.
>
> Regards
> MANI PS
> -------------------------------------------------
> Sify Mail - now with Anti-virus protection powered by Trend Micro, USA.
> Know more at http://mail.sify.com
>
> Want to get into IIM? Take the Sify Mock CAT now!
> http://education.sify.com/mockcat
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: mani
> INET: manisiva2002_at_sify.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: Tim Gorman
INET: Tim_at_SageLogix.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 Mon Sep 02 2002 - 09:53:19 CDT
