Re: Oracle 7.3 and Memory Leaks

Jeff MacKenzie wrote:
>
> I have a server that maintains a pool of connections to an NT oracle
> 7.3 database using SQLNET 2.3. The server is multithreaded and
> handles each request from a client on a sperate thread that is
> launched to handle the message and dies when it is done. Each
> transaction performes a database transaction using one of the
> connections in the database pool. I am using Intersolv ODBC drivers
> for the connection. The server eventually runs out of memory and dies
> after a number of transactions. I know it is the database transaction
> because if I hook up to a NT SQL Server it does not happen. Does
> anyone know of any memory leaks in SQLNET 2.3 that may cause this to
> happen?
>
> Thanks

Jeff,

We have had alot of problems with Oracle NT leaking memory. If you are using the OCI library, the server leaks memory that Oracle has a fix for. I believe the patch is 7.3.2.2.1 and fixes the server side. We currently have an open TAR on the client leak which is caused by SQLNET 2.3. Oracle tells us that they have fixed it and are currently in the process of 'packaging' it up, whatever that means, and should be available soon.

Casey Received on Wed Jan 22 1997 - 00:00:00 CST