Re: SQL: different execution plans at different times

From: Wolfgang Breitling <breitliw_at_centrexcc.com>
Date: Wed, 01 Nov 2006 14:22:05 -0800
Message-ID: <1162419725.45491e0d52fe3@webmail.hosting.telus.net>

Did you disable the automatic statistics gathering job in 10g? Can you verify that there are no histograms on any of the predicate columns. I know, you quote your stats gathering job as using " method_opt=>'for all columns size 1' " but double-check anyways.
Is any of the tables by any change partitioned on any of the predicate columns? CNY# would be the most likely candidate. I hope no one would partition on status or visible.

Quoting Nirmalya Das <nirmalya_at_hln.com>:

--

regards

Wolfgang Breitling
Oracle 7,8,8i,9i OCP DBA
Centrex Consulting Corporation
www.centrexcc.com

--

http://www.freelists.org/webpage/oracle-l Received on Wed Nov 01 2006 - 16:22:05 CST