RE: LIOs from 10g when using CPU_TEST.SQL

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.

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