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