My Oracle Support Banner

Stored Outlines Are Getting Used When CURSOR_SHARING=FORCE (Doc ID 455926.1)

Last updated on MARCH 18, 2022

Applies to:

Oracle Database - Enterprise Edition - Version 9.2.0.7 to 10.2.0.3 [Release 9.2 to 10.2]
Information in this document applies to any platform.

Symptoms

The stored outlines are getting used despite the cursor_sharing=force.

If the stored outlines are created manually using create outline command, it is getting used irrespective of the value set to the cursor_sharing parameter.

This is also found working in 9iR2 latest patchset (9.2.0.8) and 10gR2 latest patchset (10.2.0.3).

Cause

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
Symptoms
Cause
Solution

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