My Oracle Support Banner

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

Last updated on MAY 12, 2022

Applies to:

Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A 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.