Devart Forums

Hi,

TOraSession Connect/Disconnect causes memory leak.
In task manager the handles increasing again and again.

I've tested it with ODAC v.5.80.0.42 and Borland C++ builder 5.

Loop :

TOraSession* pSession = NULL;
pSession = new TOraSession(NULL);
pSession->AutoCommit = false;
pSession->ConnectPrompt = false;
pSession->Server = "mydatabase";
pSession->Username = "myusername"
pSession->Password = "mypassword";
pSession->Connect();
pSession->Disconnect();
delete pSession;


P.S. Sorry for my bad English.

Is there a patch for this problem?

Thanks for your help.

We could not reproduce the problem. Please specify the exact version of your Oracle client.

My client is : Oracle8i Release 8.1.7.4.1.

Oups sorry :

My client is : 8.1.7.0.0
My database id : 8.1.7.4.1

I also try with :

client : 9.2.0.1.0
database : 10.2.0.1.0

The problem is the same.

Make sure that you delete TOraSession object in the loop. I can reproduce the problem when TOraSession objects are not deleted. When objects are deleted, handle count does not increase.

I delete Torasession. Is it possible to send you my codes sources?

Yes. Please send your sample to support*devart*com.

Thank you for your response by mail.

I tried with OCI_LIB (opensource project) and i have no problem. Handles not increase.

We will also test it and continue investigation.

This problem occurs because of a bug in the Oracle client.
We can reproduce the problem with the client 9.2.0.1. To fix the problem add the OraCall unit to 'uses', and add the following code to the initialization section of your unit: This disables support for multi-threaded appication in OCI. In this case handles do not leak. You can use this mode if you don't work with Oracle from several threads.

We cannot reproduce the problem with Oracle client 10.2.0.1. In this client handles do not leak with any value of the OCIThreaded variable. So you can upgrade your Oracle client to fix the problem.

Thank you for your reply.