Re: oracle 11g uses more CPU than 10g
From: Nuno Souto <dbvision_at_iinet.net.au>
Date: Thu, 07 Mar 2013 18:59:15 +1100
Message-ID: <513848D3.4010607_at_iinet.net.au>
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.
Date: Thu, 07 Mar 2013 18:59:15 +1100
Message-ID: <513848D3.4010607_at_iinet.net.au>
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_at_iinet.net.au On 6/03/2013 8:36 PM, Eagle Fan wrote:Received on Thu Mar 07 2013 - 08:59:15 CET
> 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.
>
-- http://www.freelists.org/webpage/oracle-l