|
[oracle-l]
||
[Date Prev]
[11-2006 Date Index]
[Date Next]
||
[Thread Prev]
[11-2006 Thread Index]
[Thread Next]
Re: SQL: different execution plans at different times
- From: Wolfgang Breitling <breitliw@xxxxxxxxxxxxx>
- To: nirmalya@xxxxxxx
- Date: Wed, 01 Nov 2006 14:22:05 -0800
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@xxxxxxx>:
--
regards
Wolfgang Breitling
Oracle 7,8,8i,9i OCP DBA
Centrex Consulting Corporation
www.centrexcc.com
--
http://www.freelists.org/webpage/oracle-l
|
|
