TOracleSession memory usage

[sergio.sette]

D2009, DOA 4.1.2
A simple program with an empty form with a TOracleSession component.
Running the program the task manager shows a memory usage of about 4 MB. Calling the Logon method, after the database connection is established the memory consumption jumps to 14 MB. Closing the session doesn't release the memory.
Is this memory usage normal ?

Sergio 7

 

[Marco Kalter]

The first logon will load the Oracle Call Interface libraries and will initialize the Oracle environment. This can indeed allocate 10MB. When the session is logged off this memory is indeed not freed: the libraries remain loaded, and the Oracle environment will persist.

 

[ced bz]

Tnx Marco,

is there a way to unload the OCI ? I'm writing a small tray icon application that should be as smart as possible.

s7

 

[Marco Kalter]

After disconnecting and/or freeing all TOracleSession instances, you can call DLLExit from the OracleCI unit. This will free the Oracle Environment and will unload the libraries.

 

[ced bz]

I've tried but the Task manager reports the same memory usage for my process

s7

 

[Marco Kalter]

Maybe the process memory is not immediately freed when unloading the library. That's all you can you though.