Re: LIOs from 10g when using CPU_TEST.SQL

  • From: "Tim Onions" <att755@xxxxxxxxxxx>
  • To: k.sriramkumar@xxxxxxxxx
  • Date: Tue, 10 Jan 2006 15:07:55 +0000

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¬

From: Sriram Kumar <k.sriramkumar@xxxxxxxxx>
To: att755@xxxxxxxxxxx
CC: Oracle-L@xxxxxxxxxxxxx
Subject: Re: LIOs from 10g when using CPU_TEST.SQL
Date: Tue, 10 Jan 2006 10:58:49 -0400

Hi Tim,

What was your PL/SQL optimization level set as?. Can you try with PL/SQL
optimization level as 0 and try. presently I dont have access to 10g
environment may it would be great if you can try and share the results

Cheers

Sriram Kumar

_________________________________________________________________
Are you using the latest version of MSN Messenger? Download MSN Messenger 7.5 today! http://messenger.msn.co.uk

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


Other related posts:

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