System Error 14

[juanian]

When I use PL/SQL Developer a lot, I seem to run out of some system resource. I can't tell which one it is, but it affects all other Windows applications, not just PSD (right-click contextual menus don't appear, PLS windows don't open, other application windows open 'incompletely').

I suspect that there is some kind of memory or resource leak, but I don't know how to track it down. Can someone recommend a utility that can display info on resource sizes?

It doesn't appear to be main RAM -- there's plenty free. In the old days, there used to be utilities that would display the old system resource heap sizes (or, at least what percentage Windows reported as free). I'm not sure what utilities work under XP for similar info.

Here is some information from log files:

From debug.txt:

PL/SQL Developer
  Version 7.1.4.1390
  Windows XP Professional 5.1 Build 2600 (Service Pack 2)

  Physical memory : 2,095,152 kB  (1,088,492 available)
  Paging file     : 4,033,340 kB  (2,978,716 available)
  Virtual memory  : 2,097,024 kB  (2,027,088 available)

Parameters
  C:\Program Files\PLSQL Developer\PlSqlDev.exe
  debugsql

Preferences
  Session mode: Multi
  OCI Library:
  Use OCI7: False

Preference Files

Plug-Ins

. . .

1/3/2008 4:10:34 PM  Exception: System Error.  Code: 14.
                     Not enough storage is available to complete this operation

From PlSqlDev.elf:

Exception:
---------------------------------------------------------------------------------
  2.1 Date          : Thu, 3 Jan 2008 16:05:19 -0700
  2.2 Address       : 00413D4C
  2.3 Module Name   : PlSqlDev.exe - (PL/SQL Developer)
  2.4 Module Version: 7.1.4.1390
  2.5 Type          : EOSError
  2.6 Message       : System Error.  Code:_14.
                      Not enough storage is available to complete this operation.
  2.7 ID            : 82AC
  2.8 Count         : 1
  2.9 Status        : New
  2.10 Note         :

I haven't figured out what in PSD seems to be hogging the system (or if it actually is PSD). But, if I could monitor the sizes while performing some actions, I might be able to zero in on the problem.

 

[plsql-tv]

i have exactly the same problem. Taking a deeper look into the PlSqlDev.elf file shows the contradiction:

Exception:
-------------------------------------------------------------------------------
2.1 Date : Mon, 19 Nov 2007 15:39:06 +0100
2.2 Address : 00413D44
2.3 Module Name : plsqldev.exe - (PL/SQL Developer)
2.4 Module Version: 7.1.4.1389
2.5 Type : EOSError
2.6 Message : System Error. Code:_14.
F

 

[juanian]

It looks like my system is running out of "Pool Paged Bytes", causing the problem. I've made a change in a registry setting, and I'm keeping an eye out to see if it helps. (I changed SharedSection=1024,3072,512 to SharedSection=1024,4096,512; if it helps, I'll post more details.)

 

[juanian]

The change seems to help -- I haven't had the errors since I made the change.

Here is a description of the SharedSection settings and how changes to it affect the system:

http://support.microsoft.com/kb/184802/