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.


From: Sriram Kumar <k.sriramkumar@xxxxxxxxx>
To: att755@xxxxxxxxxxx
CC: Oracle-L@xxxxxxxxxxxxx
Subject: Re: LIOs from 10g when using CPU_TEST.SQL
Date: Tue, 10 Jan 2006 10:58:49 -0400

Hi Tim,

What was your PL/SQL optimization level set as?. Can you try with PL/SQL
optimization level as 0 and try. presently I dont have access to 10g
environment may it would be great if you can try and share the results

Cheers

Sriram Kumar

_________________________________________________________________
Are you using the latest version of MSN Messenger? Download MSN Messenger 7.5 today! http://messenger.msn.co.uk


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


Other related posts: