High Memory Allocation With Managed ODP (Doc ID 1914290.1)

Last updated on AUGUST 08, 2014

Applies to:

Oracle Data Provider for .NET - Version 12.1.0.1 and later
Information in this document applies to any platform.

Symptoms

Application using the ODP.NET Managed Driver 12.1.0.1 consumes high memory during the runtime.

Output with the Sample attached to this Note is shown below:

1/100. allocated bytes: 576640
2/100. allocated bytes: 708464
3/100. allocated bytes: 840288
4/100. allocated bytes: 972144
5/100. allocated bytes: 1103968
........
97/100. allocated bytes: 13232736
98/100. allocated bytes: 13364560
99/100. allocated bytes: 13496384
100/100. allocated bytes: 13628208 <=========consumed high amount memory

The same code with un-managed driver no high memory allocation as like managed driver. Sample Code attached to the Note.

Changes

 Switched the provider from un-managed ODP (Oracle.DataAccess.dll) to Managed ODP(Oracle.ManagedDataAccess.dll)

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms