2 Replies Latest reply: Jan 7, 2013 11:09 AM by 873768 RSS

    EBS R12 database tuning

    873768
      Hi:

      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
        • 1. Re: EBS R12 database tuning
          Hussein Sawwan-Oracle
          870765 wrote:
          Hi:

          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
          Do you have the statistics collected up to date on both databases?

          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]

          Thanks,
          Hussein
          • 2. Re: EBS R12 database tuning
            873768
            Thank you very much for your reply.