Shared Cursor Issues and Flushing the SHARED_POOL (Doc ID 1288981.1)

Last updated on APRIL 06, 2015

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.4 and later
Information in this document applies to any platform.
***Checked for relevance on 29-Oct-2012***
***Checked for relevance on 27-Aug-2014***

Symptoms

One of the more difficult problems to diagnose are regarding Shared or Child Cursor issues. Many different types of errors may occur due to the nature of this memory / cursor problem.
In older versions of Oracle changing the CURSOR_SHARING parameter to EXACT was a common resolution to many cursor problems. Over time we now see many different RDBMS versions and patchset levels with their own unique cursor issues. That stated, many of these problem share similar symptoms:

Changes

No changes required if this is new implementation
Changes in client, application or database version and/or patchset may introduce the problem

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