I’m a UDB DBA. Our production support team uses Toad and their Toad sessions do not release locks after they are done their work. The Toad application can hold locks for days while in an idle state. Eventually, we often have to kill their session, because it eventually causes other applications to go into lock wait state.
Is there a Toad configuration parameter that can be used to prevent locks from being held after completing their work? Or is there some other accepted Toad practice that will prevent this from happening?
Thanks in advance for your suggestions.