Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> 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
>To: att755_at_hotmail.com
>CC: Oracle-L_at_freelists.org
>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
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Jan 10 2006 - 16:07:55 CST