Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Wrong Plan after invalidation
Hi Folks
We have a report query with bind variables. This query has 20 sql_childs. when we use literals which are taken from the sql_bind_capture view the query uses the optimal plan.I have invalidated the plan which was using the child 18 with a simple ddl operation. but CBO start to use the wrong plan of the child 20 (we tried its literals too and explain plan output gives the right plan).
Why doesn't CBO create a new right plan for me as a child 21 instead of using a stored wrong one when i invalidate the plan ???
I hope i am clear with the situation
Thanks
--
A. Coskan GUNDOGAR
Oracle DBA
--
http://www.freelists.org/webpage/oracle-l
Received on Tue Apr 03 2007 - 08:59:50 CDT