See Connor's comment, which explains pl/sql array optimization. -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Tim Onions Sent: Tuesday, January 10, 2006 10:08 AM To: k.sriramkumar@xxxxxxxxx Cc: Oracle-L@xxxxxxxxxxxxx Subject: Re: LIOs from 10g when using CPU_TEST.SQL Sriram Bingo! when I ALTER system set plsql_optimization_level=0; and re-run the results are near enough what I get on 9.2.0.7. I'll read the FM but any pointers as to why this reduces LIO would be greatly be appreciated. T¬ >From: Sriram Kumar <k.sriramkumar@xxxxxxxxx> >To: att755@xxxxxxxxxxx >CC: Oracle-L@xxxxxxxxxxxxx >Subject: Re: LIOs from 10g when using CPU_TEST.SQL >Date: Tue, 10 Jan 2006 10:58:49 -0400 > >Hi Tim, > >What was your PL/SQL optimization level set as?. Can you try with >PL/SQL optimization level as 0 and try. presently I dont have access to >10g environment may it would be great if you can try and share the >results > >Cheers > >Sriram Kumar _________________________________________________________________ Are you using the latest version of MSN Messenger? Download MSN Messenger 7.5 today! http://messenger.msn.co.uk -- http://www.freelists.org/webpage/oracle-l -- http://www.freelists.org/webpage/oracle-l