Re: Shared pool Memory question.

Ryan Gaffuri wrote:
>
> 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
A piece of code uses (and finishes) with (say) 2000 bytes of memory. It then returns 1900 bytes for reuse. Thus 100 bytes are not being used by it - but cannot be used by anything else. Do this a few million times and all of a sudden your RAM is toast!

hth
connor

-- 
==============================
Connor McDonald

http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue..."