oracle 11g uses more CPU than 10g

From: Eagle Fan <eagle.f_at_gmail.com>
Date: Wed, 6 Mar 2013 17:36:44 +0800
Message-ID: <CANHUaOqMHDFhLXm3tGd-4bLo6DJ0a5WR0hxanPFRpTF-8vc7GA_at_mail.gmail.com>

hi:
The databases was upgraded from 10204 to 11203 version. After upgrade, we found that the CPU increased more than 30%.

Compare the top SQLs CPU time before and after upgrade, I can see big difference (15%~35%):

But buffer gets don't have much difference.

These SQLs are very simple PK lookup & Nest Loop SQLs.

Does anybody know why the CPU per execution is increased so much?

Thanks.

Eagle Fan (www.dbafan.com)

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Mar 06 2013 - 10:36:44 CET