Re: LIOs from 10g when using CPU_TEST.SQL
- From: Sriram Kumar <k.sriramkumar@xxxxxxxxx>
- To: "Allen, Brandon" <Brandon.Allen@xxxxxxxxxxx>
- Date: Tue, 10 Jan 2006 13:50:14 -0400
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 <Brandon.Allen@xxxxxxxxxxx> 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@xxxxxxxxxxxxx
> [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Tim Onions
> Sent: Tuesday, January 10, 2006 8:08 AM
> To: k.sriramkumar@xxxxxxxxx
> Cc: Oracle-L@xxxxxxxxxxxxx
> 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.
>
>
Other related posts:
