Oracle mechanics

Igor Usoltsev's Oracle blog

Optimizer point of view on literal values usage

Posted by Игорь Усольцев on August 5, 2011

Limitations of the Oracle Cost Based Optimizer [ID 212809.1]:

“From the optimizer point of view, it is recommended to use literal values where there is the possibility of significant performance differences associated with using different bind variable values and applying the same plan for all executions. In these cases the choice of a good plan usually significantly outweighs the potential usage of shared pool space (assuming that the shared pool usage is not excessive)”

It seems interesting for me! This quote from MOS doc is not ancient – last update 25-JUL-2011. Bind peeking ( from 9i), and Adaptive Cursor Sharing (11g) technologies work for a long time already, but the literal values usage are still preferable for CBO %)

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
%d bloggers like this: