Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: LIOs from 10g when using CPU_TEST.SQL

Re: LIOs from 10g when using CPU_TEST.SQL

From: Tim Onions <att755_at_hotmail.com>
Date: 2006-01-10 16:07:55
Message-id: BAY105-F39BD93992EAD3DBC47F6BB99250@phx.gbl


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



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
Received on Tue Jan 10 2006 - 16:07:55 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US