-
Title
I cannot kill an Oracle background process 25% of the time. -
Description
Im trying to kill a background process for a query running in Oracle and 25% for the time it does not kill the query but instead it hangs Toad. When I use Task Manger to terminate Toad and re-start, I always get the following error when running any query for the first time after Toad dies.
System.Exception
NET: Unknown error 1
Stack Trace:
at Quest.Toad.Editor.ScriptEngineManager.ChangeSchema(ScriptEngine engine, String schema)
at Quest.Toad.Db.ScriptEngine.ExecuteBackground() -
Cause
One identified cause of this issue is when user is connect to Oracle directly and not via TNS. Direct connect bypasses the OCI layer which prevents Toad from properly terminating a session.
-
Resolution
WORKAROUND:
Use the TNS method to connect to Oracle. -
Additional Information
1. It does not matter what types of query I ran. Simple or complex all see this behavior.
2. It does not matter which Schema I ran with.
3. The result set is anywhere from one record to thousands of records.