Re: Function of the connection?
I know there are several commands that a client can use to set its own timeout settings for its connection. I'm wondering if there is some way to set a global timeout on the database or server itself. This would be applied to all connections (perhaps unless they specify their own timeouts).
The problem we are having is that a client process locks a table and then goes off into never-never land. It doesn't die, so the connection remains, as does the lock. Any client-connection-specified timeouts wouldn't apply because the database DID respond promptly. Unfortunately, the database never tells the client process "Hey, you've had that table locked for 2 days; go away and let somebody else play with it."
I hope I'm getting my point across. I'm hampered because not only am I not a real DBA, I don't even play one on television!
Brian Bronson
