This discussion is archived
5 Replies Latest reply: Feb 5, 2013 11:29 AM by marksmithusa RSS

slow performance issue on database after migration to 11g

Santosh Pradhan Explorer
Currently Being Moderated
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

Legend

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