Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> tracking oracle memory usage

tracking oracle memory usage

From: Jim Neugebauer <neugjj_at_yahoo.com>
Date: Thu, 08 May 2003 13:37:30 -0800
Message-ID: <F001.00594994.20030508133730@fatcity.com>


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 Yahoo! Search - Faster. Easier. Bingo.
--

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

Author: Jim Neugebauer
  INET: neugjj_at_yahoo.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). Received on Thu May 08 2003 - 16:37:30 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US