Re: limit oracle memory
Date: Sun, 26 Jul 2009 15:09:27 GMT
On Fri, 24 Jul 2009 15:08:01 -0700 (PDT), John Hurley <johnbhurley_at_sbcglobal.net> wrote:
>On Jul 24, 5:22špm, NetComrade <netcomradeNS..._at_bookexchange.net>
>> 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/
>Are you using huge pages on linux?
No, it's not an issue.
>Do you understand the difference between memory that a process
>allocates and shared memory?
Yes. But I don't see how this is relevant.
>What is OOS?
Sorry, meant OOM (and provided a link above)
>What process was it that used up al the memory?
We don't know. We just know that the box hung,and an out of memory message was on the console.
>It is not hard to write a script that checks how much memory a process
We've put a number of these in place, however, we believe something
exhausts memory so fast, that none of the monitors or scripts capture
what's going on. We believe it's
We run Oracle 9iR2,10gR2, 10g2RAC on RH4/RH5 and Solaris 10 (Sparc) We use RMAN and remote catalog for backups Received on Sun Jul 26 2009 - 10:09:27 CDT