ArcSDE/Oracle connection management from Python

Discussion created by ramakan on Jan 23, 2013
Latest reply on Jan 23, 2013 by csny490
I am a user with non-admin rights on a versioned ArcSDE Oracle geodatabase. I am writing a Python 2.6 script, and running it in ArcGIS 10.0 SP4. The script opens a connection from an .SDE file. I need to do some connection management, since during the debugging process the script crashes, leaves open connections on the SDE server, and eventually I get schema lock error messages, requiring that the gdb admin kill the open sessions in the server. Is there a way to manage these connections from my Python script, and to remove them either at the end of a successful script or run, or within a finally clause in a try-catch-finally code block?