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

  • From: "Juan Carlos Reyes Pacheco" <jreyes@xxxxxxxxxxxxxxxx>
  • To: <oracle-l@xxxxxxxxxxxxx>
  • Date: Thu, 24 Jun 2004 18:23:47 -0400

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

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 06-2004