870765 wrote:Do you have the statistics collected up to date on both databases?
A developer said the explain plan for one query in two diffenent database are different. One cost is much less another. How do I check the settings for both databases? The two database (11g) should have the same setting.
Thank you for your help in advance