Re: oracle can ignore hints

  • From: Wolfgang Breitling <breitliw@xxxxxxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Fri, 05 Mar 2004 08:57:27 -0700

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.


Wolfgang Breitling
Oracle7, 8, 8i, 9i OCP DBA
Centrex Consulting Corporation

---------------------------------------------------------------- Please see the official ORACLE-L FAQ: ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at // FAQ is at // -----------------------------------------------------------------

Other related posts: