Posted By: Mindaugas Output problems "Out of memory" - 11/13/07 03:44 PM
Rescently I executed long insert SQL file.

After an hour, I've got an error "Out of memory".
Is there any way to make IDE automatically manage output size, to some limited number of lines or smth?

In preferences there is only buffer size, and autoclear on NEW script. There is no autoclear, when buffer size exceeded. Instead, it rises an error (and stops all insert process).

And more, when you get more and more lines, program performance gets slower and slower.
Posted By: Marco Kalter Re: Output problems "Out of memory" - 11/13/07 11:11 PM
Which PL/SQL Developer version are you using?
Posted By: Mindaugas Re: Output problems "Out of memory" - 11/14/07 05:44 PM
PL/SQL Developer
Version 7.1.4.1389
01.39295 - 5 user license
Windows XP Professional 5.1 Build 2600 (Service Pack 2)

Physical memory : 1.023.216 kB (372.028 available)
Paging file : 2.463.448 kB (1.479.932 available)
Virtual memory : 2.097.024 kB (1.923.876 available)
Posted By: Marco Kalter Re: Output problems "Out of memory" - 11/14/07 11:30 PM
Do you have a "Maximum result set size" preference set (Tools > Preferences > SQL Windows)?
Posted By: Mindaugas Re: Output problems "Out of memory" - 11/19/07 11:55 AM
Yes, 100MB, Application default.
Posted By: Marco Kalter Re: Output problems "Out of memory" - 11/19/07 11:07 PM
In that case you should get a warning when about 100MB of results are fetched. This is not the case?
Posted By: al666 Re: Output problems "Out of memory" - 11/21/07 12:18 PM
[quote]Originally posted by Mindaugas:
Rescently I executed long insert SQL file.

After an hour, I've got an error "Out of memory".
Is there any way to make IDE automatically manage output size, to some limited number of lines or smth?
[/quote]You execute insert SQL, right? What "output size" are you talking about then?
Posted By: Kirurgs Re: Output problems "Out of memory" - 11/21/07 05:49 PM
Related problem here.
Usually I use rather good machine with 2Gb of memory, but now I have to use one with 512Mb. The problem is that PL/SQLDev is using too much memory for not that much open windows. In developer I opened at about 10-13 windows, like 5 packages, all other are sql scripts and command window. So developer uses 300Mb for that. To me it seems too much.
Is this a known memory problem or this is specific case?
Posted By: Marco Kalter Re: Output problems "Out of memory" - 11/21/07 10:59 PM
Are you using the current 7.1.4 version?
Posted By: Kirurgs Re: Output problems "Out of memory" - 11/22/07 02:01 PM
Well, that one is temporary machine with 7.1.2.xxxx trial laugh
I'll try 7.1.4...
© Allround Automations forums