5 Replies Latest reply: Feb 5, 2013 1:29 PM by marksmithusa RSS

    slow performance issue on database after migration to 11g

    Santosh Pradhan
      We have recently migrated database from 10g to 11.2.0.2 enterprise edition and now we are facing slow performance issue on database .

      Morever we have observed that paging size has increased to 90% which was around 20-30% before migration.

      and also CPU increased to 100%.

      Details :
      RAM : 16gb
      SWAP : 8gb
      sga_target : 9gb
      pga : 2.3gb