X-list: oracle-l Return-Path: Subject: Re: LIOs from 10g when using CPU_TEST.SQL From: Andy Rivenes Message-id: 6.0.0.22.2.20060110141849.028df0e0@mail.llnl.gov Date: 2006-01-10 23:20:37 Tim, if you send me any changes you make to the script I'll post a new version. Andy Rivenes Email: arivenes@llnl.gov 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