My Oracle Support Banner

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

Last updated on AUGUST 04, 2018

Applies to:

Oracle Database - Enterprise Edition - Version and later
Information in this document applies to any platform.


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:


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


To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.