Re: sqlplus memory leak?

I guess I'm not exactly sure what you're asking. Are you concerned about:

• memory usage of the sqlplus process
• cpu usage of the sqlplus process
• memory usage of the Oracle server process
• cpu usage of the Oracle server process

or a combination of the above?

sqlplus is just a client application, not a server, so as Volker mentioned, even if there's any memory leaked, that memory will be returned to the OS when the process exits. I don't see a need for concern there.

Cheers,
Dave

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
Received on Wed Jun 25 2003 - 15:11:13 CDT