I run a query in Toad for Oracle 11.0 and runs out of memory when uses F5.
I do not run out of memory when uses F9, however when I tries to output to Excel, the export window has focus and I can no problem longer use Toad for Oracle until export is complete. This usually takes an hour for each of the five queries. This ties up this instance of Toad for Oracle until the export completes.
If I try to open up, other Toad for Oracle instances, to do simultaneous Excel exports, I will once again run out of memory.
In this example, the data returned is only 2.5 MB in excel and is only 33K lines. It crashes at 10KB and there is only standards datatypes be returned (varachr2, numbers, etc, no problem blobs or clobs).
Sometimes Toad for Oracle will crash and give return an error, sometimes it will simply disappear off the desktop. The error comes quickly usually within a minute.
It was simple query that called on a Materialized View. This Material view had a VIEW that called on at least seven TABLES. This query was quite involved and complex.
SQL*Plus or SQL designer do not have any problem running the query.
Waiting for fix in a future version of Toad for Oracle.