Quoting Germer, Carsten <[EMAIL PROTECTED]>:
> 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

_______________________________________________
Zope-DB mailing list
Zope-DB@zope.org
http://mail.zope.org/mailman/listinfo/zope-db

Reply via email to