RE: DB performance after upgrade from 9i to 11gR2
- From: "Powell, Mark" <mark.powell2@xxxxxx>
- To: "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 8 May 2014 13:10:23 +0000
BA, what kind of memory management is in use. You said the plans look good but
the queries just do not complete so this makes me wonder if the system is
waiting on AMM memory management operations to complete.
Have you checked the disk performance?
What about other OS measures: cpu utilization and memory?
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Bheemsen Aitha
Sent: Thursday, May 08, 2014 2:40 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: DB performance after upgrade from 9i to 11gR2
Hello DBA gurus,
We recently upgraded our database from 9i to 11gR2 on Solaris 11 64-bit,
Veritas File system (single instance). We tested thoroughly in our QA
environment before the upgrade. But after the upgrade we are seeing terrible
performance in production with many of the queries. Even though the query plan
looks good with very low cost, the queries are just sitting there and not
finishing. Some of the queries have differences in plan (FTS to index scans on
small tables) when compared to QA environment. We gathered stats with default
auto sample size and default method_opt options. I opened a ticket with oracle
on the performance issue, but I doubt if I can get a solution on this. The QA
and prod environments are exactly same, but the queries are running are faster
in QA. Did anyone come across similar problem in the past? Any inputs are
greatly appreciated.
Thanks
BA
Other related posts:
