64-bit: Memory issue with Oracle Provider for OLE DB

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: "Phlippie Smit" <Phlippie Smit@xxxxxxxxxxxxxxxxxxxxxxxxx>
Date: Wed, 3 Aug 2005 03:29:03 -0700

When executing "SELECT INTO" queries from linked Oracle servers using the
64-bit Provider for Oracle (Microsoft does not have one I know of), memory
leaks until the server generates stack overflow errors.

Does anyone know of thsi issue? Is there a OLE DB Provider for Windows 2003
Datacentre Server 64-bit ia64? Is there a fix for the memory leak on the
provider - I was thinking to install the ODAC package from Oracle and the 10g
OLE DB driver, but I would first like to understand the problem.

When looking at taskmgr, sqlservr.exe is using the memory.

Any help or suggestion will be much appreciated.

.

Follow-Ups:
- RE: 64-bit: Memory issue with Oracle Provider for OLE DB
  - From: VN

Prev by Date: Implementing GetColumnInfo, A static function is no good!
Next by Date: Syntax for calling DB2/remote stored proc via linked server.
Previous by thread: Implementing GetColumnInfo, A static function is no good!
Next by thread: RE: 64-bit: Memory issue with Oracle Provider for OLE DB
Index(es):
- Date
- Thread

Relevant Pages

Cant get Oracle OLE DB provider to work from SSIS on a 64-bit environment
... I posted this question in the .server newsgroup yesterday, but apparently my cross-post to this newsgroup didn't made it, so now I post it once more. ... I'm having some troubles setting up an Oracle datasource on a SSIS ... Since this Provider isn't available in the 64-bit version I ... I'd love to uninstall both Oracle clients and then try just to install ...
(microsoft.public.sqlserver.dts)
Re: Oracle Database Access via IIS 6.0 ASP Pages on Windows 2003 S
... communicate back through IIS to SQL*NET installed for the Oracle Client. ... Microsoft SQL Server 2000 Standard with SP3a installed on same box. ... Microsoft OLE DB Provider for ODBC Drivers error '80004005' ...
(microsoft.public.inetserver.iis)
[HPADM] Summary: vmunix: file: table is full & oracle client ORA-12500: TNS:listener failed
... Oracle, we never have this issue as the settings closely ... NFILE should be changed to 5000, ... 4Gb memory and he ever encounter a case on this server that if these are ...
(HP-UX-Admin)
Error initializing provider (Microsoft OLE DB provider for oracle)
... administrator account in win2k server. ... When Microsoft OLE DB Provider for Oracle is used as new data source ... it gives "An error in initializing provider. ...
(microsoft.public.sqlserver.olap)
Re: Oracle 10g on Windows 2003 x64 Memory Useage
... We are running Oracle 10g on a Quad Dual Core Windows 2003 x64 ... Enterprise Server with 16GB of memory. ... I notice that the Oracle ...
(comp.databases.oracle.server)