out of memory

dgw

Member
I am running pl/sql Developer v 12.0.1.1814 (32 bit) and am running out of memory. Is there a way to allocate more memory in the program?

I am running a query in sql window. the program stops and generates the following log:

OS : Microsoft Windows 7 (64 bit)
RAD : BDS 16.0
Dump : $83 $C0 $0C $5A $C7 $40 $F8 $01 $00 $00 $00 $89 $50 $FC $66 $C7 $04 $50 $00 $00 $66 $C7 $40 $F6 $02 $00 $8B $15 $04 $A9 $BD $01
Section : ExceptionHandlerHook
Descr :

Address : $0040C34B - [00400000] plsqldev.exe - System - - _NewUnicodeString - 0[19]
Module : plsqldev.exe
Exception : EOutOfMemory
Message : Out of memory
Call Stack : 00 $0040C34B - [00400000] plsqldev.exe - System - - _NewUnicodeString
01 $0076472B - [00400000] plsqldev.exe - ExceptionLog7 - - FullInternalErrorReport - 693[1591]
02 $00521F98 - [00400000] plsqldev.exe - EBase - - InternalErrorSet - 1586[572]
03 $00756499 - [00400000] plsqldev.exe - EInject - - ExceptionHandlerHook - 636[205]
04 $77EF49BC - [77E80000] ntdll.dll - ntdll - - (possible RtlGetProcessHeaps+1179)
05 $77EE371D - [77E80000] ntdll.dll - ntdll - - (possible RtlCaptureContext+386)
06 $77EE33DD - [77E80000] ntdll.dll - ntdll - - (possible RtlDestroyEnvironment+895)
07 $77E9013E - [77E80000] ntdll.dll - ntdll - - KiUserExceptionDispatcher
08 $005A2218 - [00400000] plsqldev.exe - EThreadsManager - - RaiseExceptionHook - 1608[312]
09 $0075610B - [00400000] plsqldev.exe - EInject - - RaiseExceptionProcHook - 482[107]
0A $004EC35D - [00400000] plsqldev.exe - System.Classes - TMemoryStream - Realloc
0B $004070D6 - [00400000] plsqldev.exe - System - - ErrorAt
0C $004EC35D - [00400000] plsqldev.exe - System.Classes - TMemoryStream - Realloc

LastAddr :
LastModule :
LastException :
LastMessage :
Call Stack :

ActiveObj : (EOutOfMemory) Out of memory
ActiveAddr : $004EC362 - [00400000] plsqldev.exe - System.Classes - TMemoryStream - Realloc - 0[78]
 
It did occur on a large result set. I resolved the problem by upping the paging file size on my PC. I did not realize the latest version uses the memory on the PC instead of the ORACLE server memory. This seems to be a change from previous versions.
 
Back
Top