TOracleDirectPathLoader - Memory leak?!?!

[F.Townsend]

I have a simple application that loads files to a table using TOracleDirectPathLoader. The app will keep checking the directory (using timer component) and load the files if there are any to load. It only connects to DB if there are files to load - otherwise it disconnects and waits for files to arrive. The VM size of this application grows at an alarming rate!! There is nothing in my code that will cause this to happen. Why is this happening? Any ideas??????

 

[Marco Kalter]

I did a little test on Oracle 9.0, and memory usage does not increase. Can you let me know your Oracle version?

I used the DirectPath demo project to verify this, by selecting a 300KB file and loading it 1000 times:

for i := 1 to 1000 do DirectPathLoadBenchmark;

Can you make the same modification to this demo and verify memory usage?

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