Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Comparing plans across instances

Comparing plans across instances

From: <hasta_l3_at_hotmail.com>
Date: 23 Sep 2006 01:29:06 -0700
Message-ID: <1159000146.673484.265230@e3g2000cwe.googlegroups.com> 





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)  ?
Received on Sat Sep 23 2006 - 03:29:06 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US