Increase memory allocation in TOAD [closed]

Closed. This question is off-topic. It is not currently accepting answers.

---

Want to improve this question? Update the question so it's on-topic for Stack Overflow.

Closed 11 years ago.

开发者_开发知识库 Improve this question

How to start TOAD with a bigger memory allocation?

Whenever I try to execute a proc in TOAD that deals with large data sets, it hangs!

---

Are you sure the problem is inside TOAD? If you are running a database procedure that deals with a large amount of data internally, it won't necessarily need to return all that data to TOAD. Have you monitored the memory usage of TOAD while the procedure is executing?

Can you execute the same procedure using SQLPlus?