This content has been marked as final. Show 2 replies
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
Compare the spfile/pfile between the two databases.
Please also see these docs.
Database Initialization Parameters for Oracle Applications Release 11i [ID 216205.1]
Database Initialization Parameters for Oracle E-Business Suite Release 12 [ID 396009.1]
Tuning performance on eBusiness suite [ID 744143.1]
bde_chk_cbo.sql - EBS initialization parameters - Healthcheck [ID 174605.1]
Thank you very much for your reply.