Our problem is that the memory is not returned to the OS when no
scripts are active. Rebooting seems to be the only remedy to reclaim
mem.
Pim
Dave Hau <davehau_nospam_123_at_nospam_netscape.net> wrote in message news:<3EFA01E0.7040309_at_nospam_netscape.net>...
> 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 Thu Jun 26 2003 - 01:50:52 CDT
