mod_plsql cleanup thread seems not to clean up (9iAS v1.02 on NT)

Hi

The application we are running is an e-shop with around 40-50 orders a day.

It was working so-so on the previous config (NT-OAS4-8.0) so we thought moving to iAS and 8.1 should increase the peformance. Instead we now have problems when the no of processes starts to grow on the dbserver.

Now we are running 9iAS v1.02 on NT.
We have a DAD connecting to a 8.1.6.0.0 database on Solaris. (Previously we ran OAS4 and 8.0 on the same NT.)

We have "Keep Database Connection Open Between Requests" set to "Yes"

According to the documentation "Oracle9i Application Server Using the PL/SQL Gateway
Release 1.0.2.1"

The mod_plsql has a cleanup thread supposed to "periodically cleans up database sessions which are inactive for more than 15 minutes."

It seems that sometimes this cleanup doesn't work.

I have kept a log of # of processes and most of the time there's 18-22 processes,
at periods going up to 30-35, and then dropping after a while, but a few times, it has been going up to 60-70, and the iAS doesn't respond anymore.
If you look at the processes many of them have been started more than two hours ago.
Looking at the dbserver, the cpu was working 100%, mostly iowait.

Anyone have any suggestions Received on Fri Nov 23 2001 - 08:58:54 CST