Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: LIOs from 10g when using CPU_TEST.SQL
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-lReceived on Tue Jan 10 2006 - 23:20:37 CST
![]() |
![]() |