Hello,

My batch program creates a lot of TOracleQueries and destroy them after executing. If I look in the taskmanager I see increasing the size of my program.

I use Oci 8.1 and Doa 3.4.6.4.

Searching through the forum I found that there was a problem with Oracle 8.0.x. So I tried to turn on UseOci7 and it worked.

But shouldn't the problem be resolved in Oracle 8.1?

kindly regards,
Matthias

I'm not sure if all Net 8.1.x version are memory leak free. It may be a good idea not to create/destroy lots of TOracleQuery instances in a batch program, because this also creates/frees the corresponding Oracle Net handles. You will be more prone to Net 8 resource leaks that way.

------------------
Marco Kalter
Allround Automations

I have gotten around this by using a global TOracleQuery for general use. You don't have to keep instantiating the rascal, which makes it pretty quick.