Output problems "Out of memory"

[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?

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.

 

[Marco Kalter]

Which PL/SQL Developer version are you using?

 

[Mindaugas]

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)

 

[Marco Kalter]

Do you have a "Maximum result set size" preference set (Tools > Preferences > SQL Windows)?

 

[Mindaugas]

Yes, 100MB, Application default.

 

[Marco Kalter]

In that case you should get a warning when about 100MB of results are fetched. This is not the case?

 

[al666]

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?

You execute insert SQL, right? What "output size" are you talking about then?

 

[Kirurgs]

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?

 

[Marco Kalter]

Are you using the current 7.1.4 version?

 

[Kirurgs]

Well, that one is temporary machine with 7.1.2.xxxx trial
I'll try 7.1.4...