Re: LIOs from 10g when using CPU_TEST.SQL

Hi,

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;??

I do not have a 10g handy to test

Cheers

Sriram Kumar

On 1/10/06, Allen, Brandon wrote:
>
> Interesting, the documentation says the parameter is plsql_optimize_level
> (not optimiz*ation*), so which is it really? (I don't have a 10g instance to
> test with right now)
>
> -----Original Message-----
> From: oracle-l-bounce_at_freelists.org
> [mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Tim Onions
> Sent: Tuesday, January 10, 2006 8:08 AM
> To: k.sriramkumar_at_gmail.com
> Cc: Oracle-L_at_freelists.org
> Subject: 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.
>
> Privileged/Confidential Information may be contained in this message or
> attachments hereto. Please advise immediately if you or your employer do not
> consent to Internet email for messages of this kind. Opinions, conclusions
> and other information in this message that do not relate to the official
> business of this company shall be understood as neither given nor endorsed
> by it.
>
>
Received on Tue Jan 10 2006 - 18:50:14 CST