Applies To:
  • CitectSCADA 1.11 1.20 2.00 2.01 3.00

Every time I connect and disconnect to and from an Oracle 7 database, my available memory (physical and virtual) and windows handles go down. They are used and never returned. Eventually my system will hang or give a General Protection Fault. 

The software libraries that Citect uses to talk to Oracle databases, were designed for Oracle 6. When talking to Oracle 7, however, there is a slight incompatibility that causes memory to be used but not released until shutdown.

The only work around for this is to make permanent connections to Oracle. That is, call SQLConnect() on Citect system startup, and don't call SQLDisconnect until shutdown.