Hi
After trying to cancel the execution of a long query, a message inform that it was cancelled but the actual worksheet hangs (cannot execute anything, nor close anymore). The session/statemente continue the execution (validated in Monitor Session with other user) and even after terminate (executed completly) the original worksheet don't return.
Unchecking the option "Use OCI/Thick driver" don't help because for the SQLDev the actual session was killed but the query keep the execution on server session (eating resources).
It seems that using different Connection Type (Basic vs Custom JDBC) with OCI/thick driver will change the behaviour but both end hanging after a query cancel.
Is there some workaround for this annoying "bug"?
Thanks for the great tool
Johnny
-----------------------------------------------------------
Settings:
------------------------------------------------------------
Instant Client:
Testing the Instant Client located at C:\instantclient_19_5
Testing client directory ... OK
Testing loading Oracle JDBC driver ... OK
Testing checking Oracle JDBC driver version ... OK
Driver version: 21.3.0.0.0
Testing testing native OCI library load ... OK
----------------------------------------------------------
Use OCI/Thick driver "Checked"
----------------------------------------
OS: Windows 10 Enterprise
---------------------------------------------
sqldeveloper.oci.available true
java.runtime.version 1.8.0_311-b11