2 Replies Latest reply: Feb 4, 2011 12:10 PM by PHCharbonneau RSS

    Performance Issues in 11r1

    zinger77
      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?