Home » Infrastructure » Windows » OraOLEDBrmc10.dll and memory
OraOLEDBrmc10.dll and memory [message #217775] Mon, 05 February 2007 07:25 Go to next message
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 #217800 is a reply to message #217775] Mon, 05 February 2007 10:36 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
What version?

You may want to check for any available patches.
Re: OraOLEDBrmc10.dll and memory [message #217801 is a reply to message #217800] Mon, 05 February 2007 10:42 Go to previous message
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

Previous Topic: where can download Oracle 8i?
Next Topic: Conneting to remote database from windows
Goto Forum:
  


Current Time: Thu Nov 21 21:36:22 CST 2024