Re: oracle 11g uses more CPU than 10g
- From: Nuno Souto <dbvision@xxxxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Thu, 07 Mar 2013 18:59:15 +1100
Seeing exactly the opposite here, from 10.2.0.3 to 11.2.0.3, on Aix P6.
wE ALSO UPGRADED aIX FROM 5.3 TO 7.1.
--
Cheers
Nuno Souto
dbvision@xxxxxxxxxxxx
On 6/03/2013 8:36 PM, Eagle Fan wrote:
> 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.
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
