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

Content-Type: Text/Plain;
  charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Maybe this paper could help you =0D
 =0D
-------Original Message-------=0D
 =0D
From: oracle-l@xxxxxxxxxxxxx=0D
Date: 06/24/04 17:48:40=0D
To: 'oracle-l@xxxxxxxxxxxxx'=0D
Subject: RE: Help with view, pushing predicate, and 9i=0D
 =0D
Mark,=0D
 =0D
>We are in the process of converting this app to 9i (9.2.0.5 on Solaris=0D
>8), and in 9i, the predicate is not pushed.  This results in a full=0D
>table scan on a large table, and, abysmal performance.=0D
 =0D
Have you looked at changing OPTIMIZER_MAX_PERMUTATIONS to see if this=0D
changes the plan? The default in 8.1.7 is 80000 but in 9.2.x, it has been=
=0D
defaulted to 2000. [Btw, Apps 11i on an 8.1.7 specifically _requires_ OMP=
 to=0D
be set to 2000 and _complex_view_merging to TRUE]=0D
 =0D
Hth,=0D
John Kanagaraj <><=0D
DB Soft Inc=0D
Phone: 408-970-7002 (W)=0D
 =0D
Grace - Getting something we do NOT deserve=0D
Mercy - NOT getting something we DO deserve=0D
Click on 'http://www.needhim.org' for Grace and Mercy that is freely=0D
available!=0D
 =0D
** The opinions and facts contained in this message are entirely mine and=
 do=0D
not reflect those of my employer or customers **=0D
----------------------------------------------------------------=0D
Please see the official ORACLE-L FAQ: http://www.orafaq.com=0D
----------------------------------------------------------------=0D
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx=0D
put 'unsubscribe' in the subject line.=0D
--=0D
Archives are at http://www.freelists.org/archives/oracle-l/=0D
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html=0D
-----------------------------------------------------------------


-- Binary/unsupported file stripped by Ecartis --
-- Type: image/gif
-- File: IMSTP.gif


----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
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
-----------------------------------------------------------------

Other related posts: