TOracleQuery leaking memory

[matthias]

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

 

[Marco Kalter]

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

 

[indmolding]

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.