3 ms·
Having a poorly thought out query planner as the cornerstone of their product is a sign that the product is not that good.
by brianwawok 10y ago
Having a poorly thought out query planner as the cornerstone of their product is a sign that the product is not that good.
- chris_wot 10y agoIn all fairness, I can't really blame Oracle on this one. That's a fairly well documented issue, because Oracle places the hash value of each query into the shared SQL pool, and if CURSOR_SHARING is set to exact and you've stopped the query from aging out then Oracle will see it as a different query. That's not even really a CBO issue. But I hear your pain :-)