Wrong Plan after invalidation

From: A. Coskan Gundogar <gundogar_at_gmail.com>
Date: Tue, 3 Apr 2007 16:59:50 +0300
Message-ID: <d1f742de0704030659v77cbb03aw840ab136efe7865a@mail.gmail.com>

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://coskan.wordpress.com

--

http://www.freelists.org/webpage/oracle-l Received on Tue Apr 03 2007 - 08:59:50 CDT