RE: tracking oracle memory usage

Jim,  

Since you are on Solaris, you can use the 'pmap' utility to determine the heap component of identified processes and monitor them for large changes.. Ignore the other values (except maybe the stack). 'ps' whill show up the RSS which will include the SGA sizes as well, so that isn't reliable. Example below:
John Kanagaraj (back now!)
Oracle Applications DBA
DBSoft Inc
(W): 408-970-7002

I don't know what the future holds for me, but I do know who holds my future!

• The opinions and statements above are entirely my own and not those of my employer or clients **

$ pmap 7511

7511: oracleC4PR (DESCRIPTION=(LOCAL=no)(ADDRESS=(PROTOCOL=BEQ)))

00010000 26520K read/exec /u01/c4prdb/8.1.7/bin/oracle

01A04000 264K read/write/exec /u01/c4prdb/8.1.7/bin/oracle

01A46000 3368K read/write/exec [ heap ]

80000000 1789608K read/write/exec/shared [ ism shmid=0x1c00 ]

FEA60000 16K read/exec /usr/platform/sun4u/lib/libc_psr.so.1

FEA70000 8K read/write/exec [ anon ]

FEA80000 16K read/exec /usr/lib/libmp.so.2

FEA94000 8K read/write/exec /usr/lib/libmp.so.2

FEAA0000 120K read/exec /usr/lib/libelf.so.1

FEACE000 8K read/write/exec /usr/lib/libelf.so.1

-----Original Message-----
Sent: Thursday, May 08, 2003 2:38 PM
To: Multiple recipients of list ORACLE-L

Hello All -  

I am in need of some advice on tracking memory usage for oracle connected processes. We thought we may have a memory leak in some of the processes attached to oracle on one of our servers... turns out that it was probobly another process on the server that ate up all the memory.. I would like to have a script or process ready next time to make it easier to track memory utilization for all processes attached to the database. I am using 8.1.7.3 on Solaris 2.6.  

I know there are memory stats in v$sgastat, what about PGA memory stats? Are there v$view(s) or sys tables that contain memory information on the session level? I am currently using unix pmap to get heap size for each session and storing the PID, heap size, and timestamp in a table to see if heap is growing for any sessions... is there an easier way to identify possible memory leak(s) if oracle does not detect it?  

Thanks!  

Jim Neugebauer
Oracle DBA
Ameritrade Holding Corp

Do you Yahoo!?
The New <http://us.rd.yahoo.com/search/mailsig/*http://search.yahoo.com> Yahoo! Search - Faster. Easier. Bingo.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: John Kanagaraj
  INET: john.kanagaraj_at_hds.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
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).