Re: Memory leak

Thats completely irrelevant in sense of paging. Paging is paging is paging, no matter what some utilities say about process memory usage.

When top shows I got 99% memory free, but I still have 20MB/s paging disk activity - I have a problem.

Tanel.

"Peter Sylvester" <peters_no_spam_please_at_mitre.org> wrote in message news:bkptpb$b6f$1_at_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 - 16:47:56 CDT