Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

SQL Performance very slow after upgrade.

user1297334Dec 18 2012 — edited Jan 2 2013

We recently upgraded from 10.2.0.5 to 11.2.0.1, and the performance of some of our SQL queries has slowed considerably. In one example a query that runs almost instantly in 10g takes over 30 seconds in 11g. When I run an autotrace, the LAST_CR_BUFFER_GETS in 10g is 1067 and in 11g it's 621006!!!

I don't know why the same exact query would produce such different results. I'm sure it is a tuning issue, but any ideas on where to start would be much appreciated.

This post has been answered by Rob_J on Dec 19 2012

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 30 2013

Added on Dec 18 2012

#database-upgrade, #performance, #sql

5 comments

2,927 views