Toad not releasing processes in an Oracle multi-thread processor environment (4307365)

If a Toad user runs a query which has more records than the value of the OCI array buffer (i.e. how many records to be fetched in one round), and the user does not scroll down to the end (or run another query), processes are not released at the Oracle end. In an Oracle multiple thread processing environment, this results in other processes having to run in a single thread process instead of running in multiple threads.

An option should be available to set a time-out to release the process after a certain amount of inactivity in the editor window.

WORKAROUND

Increase the OCI Array buffer size to its maximum i.e. 9999. This would return 10 000 rows in one trip to the database. Any queries with less than 10000 rows would, therefore, complete and release the resources.

STATUS

Enhancement request ER33609 has been submitted to Development for consideration in a future release of Toad for Oracle.