Print Thread
Output problems "Out of memory"
#28556 11/13/07 03:44 PM
Joined: Oct 2007
Posts: 29
Vilnius, Lithuania
M
Member
OP Offline
Member
M
Joined: Oct 2007
Posts: 29
Vilnius, Lithuania
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.

Re: Output problems "Out of memory"
#28557 11/13/07 11:11 PM
Joined: Aug 1999
Posts: 22,201
Member
Offline
Member
Joined: Aug 1999
Posts: 22,201
Which PL/SQL Developer version are you using?


Marco Kalter
Allround Automations
Re: Output problems "Out of memory"
#28558 11/14/07 05:44 PM
Joined: Oct 2007
Posts: 29
Vilnius, Lithuania
M
Member
OP Offline
Member
M
Joined: Oct 2007
Posts: 29
Vilnius, Lithuania
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)

Re: Output problems "Out of memory"
#28559 11/14/07 11:30 PM
Joined: Aug 1999
Posts: 22,201
Member
Offline
Member
Joined: Aug 1999
Posts: 22,201
Do you have a "Maximum result set size" preference set (Tools > Preferences > SQL Windows)?


Marco Kalter
Allround Automations
Re: Output problems "Out of memory"
#28560 11/19/07 11:55 AM
Joined: Oct 2007
Posts: 29
Vilnius, Lithuania
M
Member
OP Offline
Member
M
Joined: Oct 2007
Posts: 29
Vilnius, Lithuania
Yes, 100MB, Application default.

Re: Output problems "Out of memory"
#28561 11/19/07 11:07 PM
Joined: Aug 1999
Posts: 22,201
Member
Offline
Member
Joined: Aug 1999
Posts: 22,201
In that case you should get a warning when about 100MB of results are fetched. This is not the case?


Marco Kalter
Allround Automations
Re: Output problems "Out of memory"
#28562 11/21/07 12:18 PM
Joined: Oct 2006
Posts: 11
A
Member
Offline
Member
A
Joined: Oct 2006
Posts: 11
[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?

Re: Output problems "Out of memory"
#28563 11/21/07 05:49 PM
Joined: Feb 2005
Posts: 59
Latvia
K
Member
Offline
Member
K
Joined: Feb 2005
Posts: 59
Latvia
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?


regards
Kirurgs
Re: Output problems "Out of memory"
#28564 11/21/07 10:59 PM
Joined: Aug 1999
Posts: 22,201
Member
Offline
Member
Joined: Aug 1999
Posts: 22,201
Are you using the current 7.1.4 version?


Marco Kalter
Allround Automations
Re: Output problems "Out of memory"
#28565 11/22/07 02:01 PM
Joined: Feb 2005
Posts: 59
Latvia
K
Member
Offline
Member
K
Joined: Feb 2005
Posts: 59
Latvia
Well, that one is temporary machine with 7.1.2.xxxx trial laugh
I'll try 7.1.4...


regards
Kirurgs

Moderated by  support 

Link Copied to Clipboard
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)
Responsive Width:

PHP: 7.1.33 Page Time: 0.026s Queries: 14 (0.007s) Memory: 2.5349 MB (Peak: 3.0393 MB) Data Comp: Off Server Time: 2024-04-23 12:11:09 UTC
Valid HTML 5 and Valid CSS