Re: LIOs from 10g when using CPU_TEST.SQL


Bingo! when I

ALTER system set plsql_optimization_level=0;

and re-run the results are near enough what I get on 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


Sriram Kumar

Are you using the latest version of MSN Messenger? Download MSN Messenger 7.5 today!


Other related posts: