Re: Memory leak

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,
> >