Re: sqlplus memory leak?

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

--
While it is a known fact that programmers
never make mistakes, it is still a good idea
to humor the users by checking for errors at
critical points in your program.
-Robert D. Schneider, "Optimizing INFORMIX
 Applications"