1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Why my report taking more time in production than in test instance

Discussion in 'Oracle Forms and Reports' started by jagadekara, Jun 26, 2015.

  1. jagadekara

    jagadekara Forum Guru

    Messages:
    1,126
    Likes Received:
    145
    Trophy Points:
    1,805
    Location:
    Pulivendula
    Hi All,

    we have one XMLP report for PO Print.

    This report is takes 30 seconds in Test instance, Same report for the same parameters taking 2 minutes in Production instance.

    So what will be the problem?
     
  2. DTSIGuy

    DTSIGuy Forum Advisor

    Messages:
    402
    Likes Received:
    58
    Trophy Points:
    410
    Location:
    Texas
    Are the two instances the same? Exactly the same? Only exception being the amount of data being returned in the query...

    CJ
     
  3. jagadekara

    jagadekara Forum Guru

    Messages:
    1,126
    Likes Received:
    145
    Trophy Points:
    1,805
    Location:
    Pulivendula
    Hi,

    The Test instance cloned from Production in last week. We are running the report for the same PO which as same as in both the instances.
     
  4. DTSIGuy

    DTSIGuy Forum Advisor

    Messages:
    402
    Likes Received:
    58
    Trophy Points:
    410
    Location:
    Texas
    If you can guarantee that the underlying query in the report is behaving the same on both instances...then I would look at the settings you have for the Concurrent Manager and perhaps invalid objects. That's just guess though...

    CJ
     
  5. jagadekara

    jagadekara Forum Guru

    Messages:
    1,126
    Likes Received:
    145
    Trophy Points:
    1,805
    Location:
    Pulivendula
    Thanks,

    If you can guarantee that the underlying query in the report is behaving the same on both instances

    Don't know. i can say same rdf. But it has lot queries in it. Same rtf also.

    I can provide you log files from both the instance, if it helps.
     
  6. DTSIGuy

    DTSIGuy Forum Advisor

    Messages:
    402
    Likes Received:
    58
    Trophy Points:
    410
    Location:
    Texas
    Would the statistics necessarily be the same on the cloned instance?
     
  7. DTSIGuy

    DTSIGuy Forum Advisor

    Messages:
    402
    Likes Received:
    58
    Trophy Points:
    410
    Location:
    Texas
    You'll also need to consider the Prod system should have to allocate more resources on the fly to handle the additional user base and the added Concurrent Requests that typically are not present on a Test system. Are you sure this report isn't simply competing for resources?