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¬ 

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


Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 01-2006