Oracle memory usage & top

From: Stefan Farestam <stefan_at_igis.se>
Date: 1997/02/26
Message-ID: <33141B19.59E2_at_igis.se>#1/1


Hi,
 We have an Oracle installation on a SUN Ultra-1 running SunOS 5.5  (Solaris). Oracle is used in a web context, so there is always  5 connections to the database open. No other applications are  running on the machine except for the servers that connect to the  webserver (through the protocol fastcgi).

 The problem we experience is ocnnected to memory usage. When  using top we get a rapported amount of 17MB free memory and a total  amount of 309MB. However, just a few weeks back the machine used  to run on 215MB and we had the same quantity of free memory. This  is strange since one would expect the amount of free memory to  increase when the size of internal memory increases.

 When analysing the situation with top, a typical oracle instance  lists as follows (we have 5 of those process running):

Memory: 309M real, 10M free, 200M swap, 546M free swap

  PID USERNAME PRI NICE SIZE RES STATE TIME WCPU CPU COMMAND 11496 daemon 5 0 123M 7184K sleep 0:07 3.26% 3.26% oracle

 However when using top and summing up the RES field (e.g. top 500),  then the amount of resident memory only sums up to 140MB and not 299MB  which would be expected (309 - 10).

 Questions:

  • Which are the best tools to analyze memory performance when using Oracle in the above context?
  • top seems to give incorrect results, are we perhaps using it incorrectly?
  • Oracle seems to consume a gigantic amount of memory (even though most of it is swapped out). Any traps to look out for? Any setting in the installation that might be adjusted?

 Any pointers/ideas etc are more than welcome!

 Thanks,
 Stefan

--
Stefan Farestam              IGIS - Industrial Grade Information Systems
<stefan_at_igis.se>             Sibyllegatan 43 - 45    Tel: +46 8 667 2848
    www.igis.se              114 42 Stockholm        Fax: +46 8 667 7898
Received on Wed Feb 26 1997 - 00:00:00 CET

Original text of this message