Re: [cx-oracle-users] cx_oracle does not close TCP/IP connections on close(); relies on Python garbage collection

[Amaury F. d'A. <ama...@gm...>]

Hi,

2011/5/14 Michael Bayer <mi...@zz...>:
> I'm assuming this is intentional behavior, as illustrated by the script below.
> Wondering what the rationale is for delaying the close of a connection until the object is garbage collected

It's true that the .close() method only calls OCISessionEnd().
OCIServerDetach() is only called by the destructor.

A former colleague already noticed this: after close(), the connection
disappears from v$session,
but is still present in v$process (or v$thread, I don't remember)
Since a closed connection can't be reopened, does this makes sense to
keep the connection alive?
IMO close() should release all resources, especially on the database server...

-- 
Amaury Forgeot d'Arc