Re: LIOs from 10g when using CPU_TEST.SQL

From: Andy Rivenes <arivenes@xxxxxxxx>
To: att755@xxxxxxxxxxx
Date: Tue, 10 Jan 2006 14:20:37 -0800

Tim, if you send me any changes you make to the script I'll post a new version.


Andy Rivenes
Email: arivenes@xxxxxxxx

At 07:07 AM 1/10/2006, Tim Onions wrote:

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.

T¬


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

References:

Re: LIOs from 10g when using CPU_TEST.SQL
From: Sriram Kumar

Re: LIOs from 10g when using CPU_TEST.SQL
From: Tim Onions

Re: LIOs from 10g when using CPU_TEST.SQL

Other related posts: