This discussion is archived
2 Replies Latest reply: Jan 7, 2013 9:09 AM by 873768 RSS

EBS R12 database tuning

873768 Newbie
Currently Being Moderated
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 Employee ACE
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    Thank you very much for your reply.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points