Re: oracle 11g uses more CPU than 10g
From: Kurt Van Meerbeeck <kurtvm_at_telenet.be>
Date: Wed, 06 Mar 2013 15:25:10 +0100 (CET)
Message-ID: <671d57c1-cd49-4d80-be60-62405ffc6610_at_tendai.telenet-ops.be>
Are you by any chance using IBM AIX ?
Date: Wed, 06 Mar 2013 15:25:10 +0100 (CET)
Message-ID: <671d57c1-cd49-4d80-be60-62405ffc6610_at_tendai.telenet-ops.be>
Are you by any chance using IBM AIX ?
if so - see Bug 12596494 : GENERALLY HIGHER CPU USAGE IN 11.2.0.2 THAN 10.2.0.4 and Bug 11689561 : HASH JOIN SLOWER IN 11.2 COMPARED TO 10.2 ON AIX
cheers,
Kurt
- Original Message ----- From: "Eagle Fan" <eagle.f_at_gmail.com> To: oracle-l_at_freelists.org Sent: Wednesday, March 6, 2013 10:36:44 AM Subject: oracle 11g uses more CPU than 10g
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
--
http://www.freelists.org/webpage/oracle-l
Received on Wed Mar 06 2013 - 15:25:10 CET