Re: Oracle eats up my RAM

In article <8jchs9$qdj$1_at_gandalf.alcom.aland.fi>,   "Jerra" <jerra_at_aland.net> wrote:
> Hi,
>
> Solaris 2.6
> Oracle 8.05
>
> We have about 50 corba servers connected to the db. Each of the
 process has
> a size about 95M (value given by the Top program).
> sort_area_size = 1M
> dblock size 8K
> db_block buffers = 6000
> multiblock read count = 8
> shared sql pool 25mb
>
> The server has 1Gb memory and it swaps. There are some other programs
> running of course, regarding the oracle processes how can they be made
> smaller?
>

how are you determining the swapping?

top is wrong (its sort of right). You have 25m shared pool + 47 meg db block buffers + (maybe -- cannot tell if you are 8.0.5 or 8.1.5 as 8.05 isn't a true version number) a 20m java shared pool (thats the default) and maybe a large pool as well. Your SGA is attached to each Oracle process. Each Oracle process "SIZE" will reflect the SGA and the "RES" will reflect the amount of SGA as well.

use /usr/proc/bin/pmap instead of top. It'll clearly show the SGA that is attached. The processes are *not* 95meg apiece (on my system top shows my 8.0.3 processes as such:

  669 oracle8    1  33    0  126M  112M sleep   7:40  0.00% oracle
  673 oracle8    1  33    0  126M  112M sleep   0:57  0.00% oracle
  679 oracle8    1  33    0  133M  120M sleep 122:17  0.00% oracle
  683 oracle8    1  33    0  132M  119M sleep  87:22  0.00% oracle
  681 oracle8    1  33    0  132M  120M sleep  70:46  0.00% oracle
 2321 oracle8    1  33    0  126M  112M sleep   8:37  0.00% oracle
 2323 oracle8    1  33    0  126M  112M sleep   8:19  0.00% oracle
  661 oracle8    1  33    0  126M  112M sleep   6:34  0.00% oracle
  665 oracle8    1  33    0  126M  112M sleep   4:41  0.00% oracle
  675 oracle8    1  33    0  126M  115M sleep   3:26  0.00% oracle
  853 oracle8    1  34    0  128M  117M sleep   0:44  0.00% oracle

well, my SGA is 112159032 bytes. You have to consider that. If you increase/descrease your SGA, you'll see the numbers reported by top go up/down a corresponding amount)

> Thanks!
>
> /Jerra
>
>

--
Thomas Kyte (tkyte_at_us.oracle.com) Oracle Service Industries
Howtos and such: http://osi.oracle.com/~tkyte/index.html
Oracle Magazine: http://www.oracle.com/oramag
Opinions are mine and do not necessarily reflect those of Oracle Corp


Sent via Deja.com http://www.deja.com/
Before you buy.