Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Shared pool Memory question.
A memory leak occurs when a process requests memory from the operating system
for some use, but does not return the memory to the system when it is done
with it. If this occurs repeatedly, the process will get so much memory that
other processes will not be able to get what they need.
The only cure in most cases is to kill the offending process. The system will regain the memory when it cleans up after it.
Rick
rkg100_at_erols.com (Ryan Gaffuri) writes:
> What is meant by the term memory leak?
>
> "Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> wrote in message news:<1016185415.10285.0.nnrp-10.9e984b29_at_news.demon.co.uk>...
> > Memory leaks are just one of those bad luck
> > things. I was on a site recently that managed
> > to leak 1.6GB of memory in 4 minutes on 8.1.7.2
> > on a system that had previously been running for
> > four months - with no recent code changes. It was
> > just a new data item appearing that happened to
> > exercise a previously unused code path.
> >
> >
> > --
> > Jonathan Lewis
> > http://www.jlcomp.demon.co.uk
> >
> > Next Seminar - UK, April 3rd - 5th
> > http://www.jlcomp.demon.co.uk/seminar.html
> >
> > Host to The Co-Operative Oracle Users' FAQ
> > http://www.jlcomp.demon.co.uk/faq/ind_faq.html
> >
> > Author of:
> > Practical Oracle 8i: Building Efficient Databases
> >
> >
> > Howard J. Rogers wrote in message ...
> > >
> > >Not sure why memory usage would be growing, off-hand. It shouldn't be.
> > >8.1.7.0 ran for months on W2K here without memory leaks, but you could
> > maybe
> > >download the 8.1.7.3 patch, and see if that helps (ftp.oracle.com has the
> > >patch set, but it's rather large!).
> > >
> > >Regards
> > >HJR
-- Rick Wessman Security Assurance Group Oracle Corporation Rick.Wessman_at_oracle.com The opinions expressed above are mine and do not necessarily reflect those of Oracle Corporation.Received on Fri Mar 15 2002 - 15:45:13 CST