Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: LIOs from 10g when using CPU_TEST.SQL

Re: LIOs from 10g when using CPU_TEST.SQL

From: Andy Rivenes <arivenes_at_llnl.gov>
Date: 2006-01-10 23:20:37
Message-id: 6.0.0.22.2.20060110141849.028df0e0@mail.llnl.gov


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

Andy Rivenes
Email: arivenes_at_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
Received on Tue Jan 10 2006 - 23:20:37 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US