hasta_l3_at_hotmail.com wrote:
> Dear group,
>
> Do you know of a tool which collects and compare the execution plans of
> a set of sql statements across Oracle database - perhaps of different
> releases ?
>
> We want to make sure that our plans do not change between O8 and O9.
>
> More generally, how do you ensure the stability of plans across O8 and
> O9 (with the rule based optimizer) ?
No but I do know that there is a very high liklihood that they will
change across versions unless you carefully follow Jonathan Lewis'
advice on fully hinting.
--
Daniel Morgan
University of Washington
Puget Sound Oracle Users Group
Received on Sat Sep 23 2006 - 11:10:06 CDT
