Re: oracle can ignore hints

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@xxxxxxxxxxxxx
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
-----------------------------------------------------------------

Other related posts: