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-11 11:04:46
Message-id: BAY105-F387053EA6DA36B10AAEE0499240@phx.gbl

My bad typing, what I actually ran was

ALTER system set plsql_optimize_level=0;

and as stated before the results became very close to the 9.2.0.7 ones.

>From: Sriram Kumar
>Subject: Re: LIOs from 10g when using CPU_TEST.SQL
>
>The parameter name as per documentation is plsql_optimize_level but is
>referred as plsql optimization level.
>
>Tim can you confirm if you executed
>
>ALTER system set plsql_optimization_level=0;
>or
>ALTER system set plsql_optimize_level=0;??
>



The new MSN Search Toolbar now includes Desktop search! http://toolbar.msn.co.uk/
--
http://www.freelists.org/webpage/oracle-l
Received on Wed Jan 11 2006 - 11:04:46 CST

Original text of this message

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