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_at_freelists.org=0D
Date: 06/24/04 18:19:36=0D
To: oracle-l_at_freelists.org=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_at_freelists.org=3D0D=0D
Date: 06/24/04 17:48:40=3D0D=0D
To: 'oracle-l_at_freelists.org'=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_at_freelists.org=3D0D=0D
put 'unsubscribe' in the subject line.=3D0D=0D
--=3D0D=0D
Archives are at
http://www.freelists.org/archives/oracle-l/=3D0D=0D
FAQ is at
http://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_at_freelists.org=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_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
-----------------------------------------------------------------
Received on Thu Jun 24 2004 - 17:25:47 CDT
