[Zope-DB] Closing idle DCoracle2 Connections?

Cynthia Kiser cnk+zope at caltech.edu
Thu Oct 20 22:09:20 EDT 2005

Quoting Germer, Carsten <carsten.germer at desy.de>:
> Hello everyone,
> As we start to use our zope-Ora connection more frequently our database
> administrator complains that he sees a lot of idle conections.

I am pretty sure there is a bug in DCOracle2. If you can, try using
DCOracle2 from the python prompt and close the connection. Now, can
you still talk to the database? It seemed to me that I could when I
tried that. 

For my particular circumstance, this apparent leak in database
connections is slow enough that I just restart my Zope application
periodically. That clears the connections Oracle still thinks are
open. FYI just closing the database connection via the ZMI does not
release the idle connections Oracle still sees. 

Cynthia Kiser

More information about the Zope-DB mailing list