Re: limit oracle memory

From: Mladen Gogala <>
Date: Wed, 29 Jul 2009 19:05:50 +0000 (UTC)
Message-ID: <h4q6ie$1te$>

On Tue, 28 Jul 2009 16:07:21 +0000, NetComrade wrote:

> On Tue, 28 Jul 2009 07:43:24 +0000 (UTC), Mladen Gogala
> <> wrote:

>>Na Tue, 28 Jul 2009 01:07:15 +0000, NetComrade napisao:
>>> How do you tune virtual address space via limits.conf?

> what line of your link specifically talks about it? .......
> We run Oracle 9iR2,10gR2, 10g2RAC on RH4/RH5 and Solaris 10 (Sparc) We
> use RMAN and remote catalog for backups

You can limit resident set size (RSS) per process. That will do wonders for the memory consumption. Also, the meaning of the phrase "limit memory for oracle" is rather vague. You can limit the address space for the user "oracle", you can limit the resident set size, you can limit SGA by setting SGA_MAX_SIZE, you can activate direct I/O and cut down on the buffer consumption or you can use huge pages to exclude SGA from the normal memory management. There are many things you can do but you have to know what are you doing.

Received on Wed Jul 29 2009 - 14:05:50 CDT

Original text of this message