Re: LIOs from 10g when using CPU_TEST.SQL


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 <k.sriramkumar@xxxxxxxxx>
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/

--
//www.freelists.org/webpage/oracle-l

References:
- Re: LIOs from 10g when using CPU_TEST.SQL
  - From: Sriram Kumar