Re: Memory leak

From: Tanel Poder <change_to_my_first_name_at_integrid.info>
Date: Tue, 23 Sep 2003 15:00:24 +0300
Message-ID: <3f7035d9_1@news.estpak.ee>

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 - 07:00:24 CDT