OraOLEDBrmc10.dll and memory [message #217775] |
Mon, 05 February 2007 07:25 |
Darwex
Messages: 2 Registered: February 2007
|
Junior Member |
|
|
We've got a problem with memory when using the oracle OLEDB driver.
Our application is doing an export from a database which is very memory heavy. Everything works fine with the connection to a MSSQL database.
However when doing the same with the oracle OLEDB driver the system runs out of virtual memory.
On further investigation it appears that OraOLEDBrmc10.dll is being loaded and unloaded a great number of times during the process of export. However, if I explicitly load this dll at start then everything is fine.
Does anyone know why this dll isn't loaded once by the Oracle driver but instead is loaded & unloaded during operation ?
Also is there any reason why it would be unsafe to load this dll at startup and hold it in memory for the duration of the connection to the database ?
Thanks,
David.
|
|
|
|
Re: OraOLEDBrmc10.dll and memory [message #217801 is a reply to message #217800] |
Mon, 05 February 2007 10:42 |
Darwex
Messages: 2 Registered: February 2007
|
Junior Member |
|
|
This is a 10.2 client installation (which seems to include a 10.1 installation folder with it).
The dll in question is in $/Oracle/Product/10.1.0/Client_1/bin.
Its version is 10.1.0.2.
However I have heard that oracle clients have been doing this for quite a few versions (even back to 9).
We've tried latest version from the oracle website and this doesn't fix the problem.
Thanks anyway,
Darwex.
P.S. This is a 10G R2 client.
[Updated on: Mon, 05 February 2007 10:43] Report message to a moderator
|
|
|