Hi rjamya try to compare hidden parameters, and check if there a news, and
try to disable them, sometime this solves the problems, and helps to find
the root problem.
On 12/15/06, rjamya <rjamya_at_gmail.com> wrote:
>
> Well,
>
> I have a query that has identical plan in 9204/9208. Identical from
> trace file, using dbms_xplan, stats are pretty close (difference is
> less than 5%). In production 9204, it runs in few seconds, in 9208
> takes 4700+ seconds due to excessive index scans.
>
> Any gotcha's with 9208 that I probably missed reading?
> Cheers
> Rjamya
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>
--
----------------------------------------
http://www.oracleboliviaspecialists.com/
Oracle Certified Profesional 9i 10g
Oracle Certified Professional Developer 6i
10 years of experience from Oracle 7 to Oracle10g and developer 6i
--
http://www.freelists.org/webpage/oracle-l
Received on Fri Dec 15 2006 - 11:00:21 CST
