When I run a query in Toad, I don't get rows returned and instead I get the following message in the Output General tab at the bottom of Toad:
"<time> Info: You have reached your low memory threshold. Script aborting."
There's two ways you can run a query, with F5 (as script) or F9 (as statement). When you run it with F5, Toad tries to fetch "all" the rows into memory at once before it displays anything. Hence the increase in the memory usage that you see in Task Manager and decrease in total available memory. Depending on the available physical memory and table size, using F5 requires enough available memory to hold all the data it tries to retrieve.
The issue is irrelevant of how much RAM you have, it is the available memory you have to worry about.
RESOLUTION #1:
If running the query using F5 (as script) is causing you to reach your low memory threshold, trying running the query using F9 (as statement). Running the query using F9 retrieves blocks of rows of data at a time and hence not as memory intensive.
RESOLUTION #2:
Renaming the User Files
1. Exit out of Toad
2. Go to:
(if you running windows XP) C:\Documents and Settings\<OS user name>\Application Data\Quest Software\Toad for Oracle\10.6
(if you are using windows 7) C:\Users\<OS user name>\AppData\Roaming\Quest Software\Toad for Oracle\10.6
3. Rename the User Files folder
4. Launch Toad and replicate your issue again.
NOTE: If that doesn't help, exit Toad and delete the new User Files folder and rename back your original folder.
