# Toad Script Problem

**URL:** <https://forums.toadworld.com/t/toad-script-problem/9924>\
**Category:** Toad for Oracle & DevOps Toolkit\
**Created:** [October 12, 2010, 1:29pm UTC](https://forums.toadworld.com/t/toad-script-problem/9924 "2010-10-12T13:29:25Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![tmantoday](https://avatars.discourse-cdn.com/v4/letter/t/aeb1de/32.png) [@tmantoday](https://forums.toadworld.com/u/tmantoday)\
**Post date:** [October 12, 2010, 1:29pm UTC](https://forums.toadworld.com/t/toad-script-problem/9924/1 "2010-10-12T13:29:25Z")

</div>

Using 9.7.2.5. I whenever I try to run a script, I get “You have reached your low memory threshold. Script aborting”. I was able to run scripts at one point, but now I get this message on the “General” tab when I enable “Spool SQL to Screen”. What do I need to clear out to fix this? My OCI setting is 500. “Show script grids” is disabled. I have 1.96 GB of ram and Toad is the only app I have open.

---

<div class="post-metadata">

**Author:** ![GTDG](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/gtdg/32/140_2.png) [@GTDG](https://forums.toadworld.com/u/GTDG)\
**Post date:** [October 12, 2010, 1:29pm UTC](https://forums.toadworld.com/t/toad-script-problem/9924/2 "2010-10-12T13:29:25Z")

</div>

The reason you’re getting that message is that you’re out of memory. When you  
execute as a script (F5), Toad has to pull back the ENTIRE data set before it  
can display it. Depending on what you’re trying to return, you can run out of  
memory.

Do you really need to return the entire contents of the query ? If not, try  
running it with F9.

Do you have the history tab turned on? This will make an exact copy of the data  
and require more memory.

Can you upgrade? We’ve added some memory optimizations with each version and  
10.6 was just released.

---

<div class="post-metadata">

**Author:** ![tmantoday](https://avatars.discourse-cdn.com/v4/letter/t/aeb1de/32.png) [@tmantoday](https://forums.toadworld.com/u/tmantoday)\
**Post date:** [October 12, 2010, 2:54pm UTC](https://forums.toadworld.com/t/toad-script-problem/9924/3 "2010-10-12T14:54:10Z")

</div>

Thanks. the query running uses “where rownum\<2”, so there’s only 1 row returned. I turned off “maintain script history” and it didn’t help. The only version the company has is this one. Is there a workaround to this problem?

---

<div class="post-metadata">

**Author:** ![tmantoday](https://avatars.discourse-cdn.com/v4/letter/t/aeb1de/32.png) [@tmantoday](https://forums.toadworld.com/u/tmantoday)\
**Post date:** [October 12, 2010, 5:03pm UTC](https://forums.toadworld.com/t/toad-script-problem/9924/4 "2010-10-12T17:03:35Z")

</div>

Yes, I can run it in F9 mode. I was also able to run it in Script mode just returning 2 rows instead of one. But now somehow the memory is not being released. I’m only running Toad on my machine.