Hi all.
I'm developing a multi-db application, supporting Oracle and SQL Server
2000. This requisites made me build a general data layer which allows
business logic to switch transparently between db servers, using ADO with
SQL Server and OCI with Oracle (through a COM DLL we built). Now, due to an
architectural choice which is not the point of this email, I had to develop
business logic functions that are opening and closing db connection for
every little transactional block of instructions. Probably this will change,
but anyway, doing a lot of open/close I observed server loosing memory
resources, eventually causing ORA-04031 and problems related. Oracle is
8.1.7.0 on Windows 2000 Advanced Server. I observed on our test server that
more or less 50.000 of open/close connection couples caused resources
exhaustion. Obviously hardware charecteristic of server could change this
number, but this is not the point for me. I would just like to know if this
server behaviour is by design because such a big number of open/close block
is not a recommended dev pattern, or if it is a bug solved in earlier Oracle
versions, or if there are server setting that can change this behaviour.
Thanks in advance, bye.
Wasp
Received on Tue Feb 04 2003 - 13:47:37 CST
