Re: oracle can ignore hints

From: Wolfgang Breitling <breitliw_at_centrexcc.com>
Date: Fri, 05 Mar 2004 08:57:27 -0700
Message-Id: <6.0.3.0.2.20040305085319.02bfb3e8@pop.centrexcc.com>

You say you used export/import to move the data from one database to the other. That may very well (most likely) create a different object creation order with the same objects having different object_ids in the two databases. AFAIK, RBO uses object_ids to break ties, so that can explain different paths in different DBs.

At 07:57 AM 3/5/2004, you wrote:
>I have had that exact same experience.
>
>Two Sun servers, different number of CPU's and RAM,
>same versions of Oracle 7 down to the patch level,
>data exported from one database into the other.
>
>Strictly RBO, two very different execution paths.
>
>Very frustrating, wish I could recall the solution we used.
>
>Jared

Wolfgang Breitling
Oracle7, 8, 8i, 9i OCP DBA
Centrex Consulting Corporation
http://www.centrexcc.com

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 Fri Mar 05 2004 - 10:29:53 CST