No problems on my 9iR2 on Suse 8.2. Running slow as heck, but system is
remaining stable and available.
"Pim" <pimreinders_at_planet.nl> wrote in message
news:c71d32c2.0306250448.42831cdd_at_posting.google.com...
> 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 - 11:16:30 CDT
