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_at_freelists.org=0D
Date: 06/24/04 17:48:40=0D
To: 'oracle-l_at_freelists.org'=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_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:18:45 CDT
