oracle 11g uses more CPU than 10g
- From: Eagle Fan <eagle.f@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Wed, 6 Mar 2013 17:36:44 +0800
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)
--
//www.freelists.org/webpage/oracle-l
Other related posts:
