"Volker Hetzer" <volker.hetzer_at_ieee.org> wrote in message news:<bdcmuu$gfk$1_at_dackel.pdb.sbs.de>...
> Pim wrote:
> > We use many linux shell scripts requesting data from our (Oracle 8i
> > enterprise 8.1.7.4.0 running on Redhat 7.1) database. Many scripts use
> > sqlplus to connect to the db.
> > When these scripts are used intensively we observe a steady growing of
> > the memory usage until the point that the swap daemon consumes all the
> > CPU capacity.
> > Anyone who can shed some light on this?
> >
> > The problem can be isolated by running the following shell script:
> >
> > ii=1
> > while [ $ii -lt 1000000 ]
> > do
> > sqlplus scott/tiger <</
> > select 1 + 1 from dual
> > quit
> > /
> > ii=`expr $ii + 1`
> > done
>
>
> But wouldn't that script point to a memory leak in your shell?
> Or are you connecting locally and the server process leaks?
> Anyway, sqlplus can't leak much from one statement and any
> possible leak will disappear with the finishing of the process.
> i.e. with the "/" in your script.
>
> Lots of Greetings!
> Volker
The problem however is that the memory is not freed when no scripts
are active. Rebooting the computer seems to be the only remedy to
reclaim mem.
Pim
Received on Thu Jun 26 2003 - 01:45:21 CDT
