Adaptive Optimisation ?

Link: http://jonathanlewis.wordpress.com/2009/12/16/adaptive-optimisation/

Here’s an interesting post and test case from Gregory Guillou (WeDoStreams blog). It features an SQL statement that is re-optimised the second time you run it.
Since it’s running on 11.2.0.1 your first thought is likely to be “SQL Plan Management”, or “Adaptive Cursor Sharing” – except the first feature wasn’t enabled, and the statement doesn’t [...]


Find us on Google+
Categories: Oracle RSS Feed
PermalinkPermalink