Oracle Data Provider for .NET

• Performance Enhancements for Oracle Database 11g Release 1 (11.1)

The following performance enhancements have been made:

ODP.NET Configuration

Developers can configure ODP.NET using configuration files, including the application config, web.config, or machine.config files. Settings in the machine.config file override the registry settings. The settings in the application config or the web.config file override the values in the machine.config.

• Improved Parameter Context Caching

This release enhances the existing caching infrastructure to cache ODP.NET parameter contexts. This enhancement is independent of database version and it is available for all the supported database versions. This feature provides significant performance improvement for the applications that execute the same statement repeatedly.

This enhancement is transparent to the developer. No code changes are needed to use this feature.

• Efficient LOB Retrieval With SecureFiles

This release improves the performance of small-sized LOB retrieval by reducing the number of round-trips to the database. This enhancement is available only with Oracle 11g Release 1.0 or later database versions.

This enhancement is transparent to the developer. No code changes are needed to use this feature.

• The following enhancements have been made to 10.2.0.3:
  • Starting 10.2.0.3, ODP.NET natively supports the 64-bit .NET Framework for the following 64-bit Windows platforms:
    • Windows x64 for AMD64 and Intel EM64T processors
    • 64-bit Windows for Intel Itanium

64-bit systems enables more scalable and better performing ODP.NET applications.

• Configuring FetchSize through the Windows registry is added to ODP.NET 10.2.0.3. This feature enables applications to specify the default result set fetch size through the registry.
• Local Transaction Support for System.Transactions feature is added to ODP.NET 10.2.0.3. This feature enables System.Transactions to use local transactions rather than distributed transactions. This can be specified either through the registry or through a connection string attribute.
• Support for Microsoft ADO.NET 2.0 is added to ODP.NET release 10.2.0.2 and includes the following:
  • Provider Factory Classes and Base Classes

Simplifies data access code to access multiple data sources with a provider generic API.

• Connection String Builder

Makes creating connections strings less error-prone and easier to manage.

• Data Source Enumerator

Enables the application to generically obtain a collection of the Oracle data sources that the application can connect to.

• Support for Schema Discovery

Permits application developers to find and return database schema information, such as tables, columns, and stored procedures.

• System.Transactions Support

ODP.NET supports implicit and explicit transactions using the System.Transactions namespace models.

• Batch Processing Support

Enables batch processing when the OracleDataAdapter.Update method is called.