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
---------------------------------------------------------------- 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 //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------