Re: Memory leak

From: Peter Sylvester <peters_no_spam_please_at_mitre.org>
Date: Tue, 23 Sep 2003 12:52:59 -0400
Message-ID: <bkptpb$b6f$1@newslocal.mitre.org>

Careful, many of the OS commands and utilities (i.e. top) include the shared SGA memory in each process that has attached to it. I'm not sure how sar handles this, but if vmstat does not show excessive page-in you should be ok. Oracle won't allocate beyond the SGA, but each server process will take a small bite (assuming dedicated server mode).

--Peter

Adolfo wrote:

> We check with top and sar -r
> 
> Our shared_pool_size  is 300000000 and our RAM is 3Gb. Someone is eating up the
> memory until we only have 40 Mb of the 3Gb. I don't undertand why oracle takes
> more memory than its 300Mb
> When we stop the select and shutdown  oracle we only recover about 300 Mb and
> with /usr/ucb/ps -aux we don't see which process have the memory
> 
> Adolfo
> 
> Tanel Poder ha escrito:
> 
> 

>>How do you see that system doesn't recover the memory? Do you get any errors
>>or just checking top output?
>>
>>It's probably not memory leak -> it's just Oracle not releasing it's shared
>>memory segments.
>>
>>Check:
>>
>>ipcs -ma
>>
>>and then
>>
>>ipcrm <shmid> to remove unwanted shared memory segments. Of course beware
>>from removing other processes segments.
>>
>>Tanel.
>>
>>----- Original Message -----
>>From: "Adolfo" <air_at_tid.es>
>>Newsgroups: comp.databases.oracle.server
>>Sent: Tuesday, September 23, 2003 1:20 PM
>>Subject: Memory leak
>>
>>
>>>Hi,
>>>
>>>We are using oracle server 8.1.7.3 and solaris 2.6. We have put the
>>>latest patchset for solaris 2.6 but when we run a heavy query the system
>>>memory go down quickly. Our SGA is 300Mb. When we shutdown our instance
>>>the system not recovery the memory and we have to reset the machine.
>>>
>>>Any ideas?
>>>
>>>Regards,
>>>
Received on Tue Sep 23 2003 - 11:52:59 CDT