Re: LIOs from 10g when using CPU_TEST.SQL
- From: "Tim Onions" <att755@xxxxxxxxxxx>
- To: k.sriramkumar@xxxxxxxxx
- Date: Wed, 11 Jan 2006 10:04:46 +0000
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/
--
http://www.freelists.org/webpage/oracle-l
- References:
- Re: LIOs from 10g when using CPU_TEST.SQL
- From: Sriram Kumar
Other related posts:
- » LIOs from 10g when using CPU_TEST.SQL
- » Re: LIOs from 10g when using CPU_TEST.SQL
- » Re: LIOs from 10g when using CPU_TEST.SQL
- » Re: LIOs from 10g when using CPU_TEST.SQL
- » Re: LIOs from 10g when using CPU_TEST.SQL
- » RE: LIOs from 10g when using CPU_TEST.SQL
- » RE: LIOs from 10g when using CPU_TEST.SQL
- » Re: LIOs from 10g when using CPU_TEST.SQL
- » Re: LIOs from 10g when using CPU_TEST.SQL
- » Re: LIOs from 10g when using CPU_TEST.SQL
- » Re: LIOs from 10g when using CPU_TEST.SQL
My bad typing, what I actually ran was
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;??
- Re: LIOs from 10g when using CPU_TEST.SQL
- From: Sriram Kumar