[Zope] Re: Leaking Oracle connections & processes

[Dieter Maurer]

Shai Berger writes:
 > ... excess Oracle processes and zombies ...
I have checked our installation and can confirm that
both problems have gone.

We do not yet know what caused the excess Oracle processes.
After an increase of Zope's ZODB cache and an upgrade
to the newest DCOracle, the problem simply went away.

We do know what caused our zombie processes:
a bug in the Oracle Java runtime library:
they had added a "NOWAIT" flag to their "wait" calls.
This ensured that a "wait" call does not release
the Zombie child but keeps it in its state.
As a consequence,
each process started from Java became a Zombie
process.
As Oracle reported, the problem was introduced in 8.1.6
and should be fixed in 8.1.7.


Dieter