Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Help with view, pushing predicate, and 9i

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

From: Juan Carlos Reyes Pacheco <jreyes_at_dazasoftware.com>
Date: Thu, 24 Jun 2004 18:23:47 -0400
Message-Id: <40DB5473.00000A.01456@CACHITOSS>


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

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US