RE: Help with view, pushing predicate, and 9i

Mark,

>We are in the process of converting this app to 9i (9.2.0.5 on Solaris
>8), and in 9i, the predicate is not pushed. This results in a full
>table scan on a large table, and, abysmal performance.

Have you looked at changing OPTIMIZER_MAX_PERMUTATIONS to see if this changes the plan? The default in 8.1.7 is 80000 but in 9.2.x, it has been defaulted to 2000. [Btw, Apps 11i on an 8.1.7 specifically _requires_ OMP to be set to 2000 and _complex_view_merging to TRUE]

Hth,
John Kanagaraj <><
DB Soft Inc
Phone: 408-970-7002 (W)

Grace - Getting something we do NOT deserve Mercy - NOT getting something we DO deserve Click on 'http://www.needhim.org' for Grace and Mercy that is freely available!

• The opinions and facts contained in this message are entirely mine and do not reflect those of my employer or customers **

  ---

  Please see the official ORACLE-L FAQ: http://www.orafaq.com

  ---

  To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

  ---