Re: limit oracle memory

From: John Hurley <johnbhurley_at_sbcglobal.net>
Date: Fri, 24 Jul 2009 15:08:01 -0700 (PDT)
Message-ID: <a7da4c2c-99fa-49dc-b2fd-30e95f413ae6_at_t13g2000yqt.googlegroups.com>



On Jul 24, 5:22 pm, NetComrade <netcomradeNS..._at_bookexchange.net> wrote:

snip

> We had a server run out of memory the other day.
>
> OS is RH 4.0
>
> Unix admin is telling me OOS stuff should've killed it, but it
> obviously did not.
>
> Is there a way to limit total memory used (not just individual
> processes) or SGA
>
> Anyone has experience setting overcommit_memory params?http://www.miljan.org/main/2009/07/10/linux-memory-management/
>
> thanks
> .......
> We run Oracle 9iR2,10gR2, 10g2RAC on RH4/RH5 and Solaris 10 (Sparc)
> We use RMAN and remote catalog for backups

Are you using huge pages on linux?

Do you understand the difference between memory that a process allocates and shared memory?

What is OOS?

What process was it that used up al the memory?

It is not hard to write a script that checks how much memory a process has allocated. Received on Fri Jul 24 2009 - 17:08:01 CDT

Original text of this message