My Oracle Support Banner

Query Using Bind Variables Suddenly Starts to Perform Slowly (Doc ID 387394.1)

Last updated on AUGUST 04, 2018

Applies to:

Oracle Database - Enterprise Edition - Version 9.0.1.0 and later
Information in this document applies to any platform.
Checked for relevance on 09-May-2013

Symptoms

Changes

The cursor has been re-parsed for some reason and a new plan has been generated.

There are many reasons why this might occur, not least the following:

NOTE: the cursor will NOT get moved out by flushing the Shared Pool if it is pinned (ie in use)

 

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!


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