Enabling the Oracle ODBC Driver Option "Enable Closing Cursors" Results in Additional Performance Overhead With the Execution of "Select Null From Dual" (Doc ID 579192.1)

Last updated on JULY 05, 2017

Applies to:

Oracle ODBC Driver - Version 9.2.0.1 to 11.1.0.6.0
Information in this document applies to any platform.

Symptoms

Enabling the Oracle ODBC driver option "Enable Closing Cursors" may negatively impact server side and application performance. The following SQL will  be generated and may appear in server side diagnostic peformance reports as TOP SQL consuming various resources.

SELECT NULL FROM DUAL



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