This discussion is archived
2 Replies Latest reply: Feb 4, 2011 10:10 AM by PHCharbonneau RSS

Performance Issues in 11r1

697715 Newbie
Currently Being Moderated
Hello all,
We have migrated from Oracle 10.2.0.4 to Oracle 11r1 for PeopleSoft HR app. "Everything" was tested by the users and performance was acceptable on the development box. However, after the upgrade - we are seeing most of the queries regress in performance. Some are running 10 times longer than they used to.

The queries run fine in 10g (we still have the dev instance on both versions.)
We'v tried gather new stats
Tried importing 10g stats
Applied patch set update: 9654987

We are still seeing very high consumption on CPU and some latch issues.
I find it interesting that in DBFlash shows me that the query is using "SYSTEM.DBF" and not the data files belonging to the actual tables. It is reading Data Dictionary info?
  • 1. Re: Performance Issues in 11r1
    697715 Newbie
    Currently Being Moderated
    BTW - in case anyone is reading this, this is due to a bug in 11g. There is a recommended patch that ORACLE should of advised to us, but 2 days of 24 hour support and even though everyone understood the problem, they could not find the solution. Finally, an independent consultant - Dale Basemen, (who is awesome) gave us the fix to add hidden parameters or to apply the patch.
  • 2. Re: Performance Issues in 11r1
    PHCharbonneau Explorer
    Currently Being Moderated
    Hi Zinger77

    Can you please provide more detail on the root cause and solution you applied to your environment?

    Thanks.
    P-H

Legend

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