RE: 15:38:00 Info: You have reached your low memory threshold.

John Dorlon <[email protected]>
Newsgroups gmane.comp.db.oracle.toad.free
Message-ID <4120B436C765EC43A31CC3E2A13D36A62255D6C0@ALVMBXW02.prod.quest.corp>
Don't worry about that.

What you need to do is avoid using all the memory in the first place.   The way to do that is in the Export Dataset dialog, be sure that the "Display all results in grid" checkbox is Unchecked.  Besides using less memory, your exports will go a lot faster that way.

Most of the time, you'll want to uncheck that checkbox.  The only time you want that checked is when both of these are true:

a)      You don't want to re-run the query for some reason (maybe it took a long time)

b)      You are sure you won't run out of memory by loading the entire result set into the grid

-John

From: [email protected] [mailto:[email protected]] On Behalf Of John Carrott
Sent: Wednesday, October 12, 2011 9:59 AM
To: [email protected]
Subject: [toad] 15:38:00 Info: You have reached your low memory threshold.



Message from: JCarrott


I am trying the export a large table to a pipe delimited CSV file. I had done this on 2 previous occations in the past year. I now get,

15:38:00 Info: You have reached your low memory threshold.  Fetch of LAWSON.POLINE aborted.

How do I change the value of the low memory threshold?

_______________________________________

Historical Messages


Author: John Carrott
Date: Wed Oct 12 07:58:56 PDT 2011
I am trying the export a large table to a pipe delimited CSV file. I had done this on 2 previous occations in the past year. I now get,

15:38:00 Info: You have reached your low memory threshold.  Fetch of LAWSON.POLINE aborted.

How do I change the value of the low memory threshold?
__
_______________________________________
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.