RE: LIOs from 10g when using CPU_TEST.SQL

From: Igor Neyman <ineyman_at_perceptron.com>
Date: 2006-01-10 16:15:03
Message-id: F4C27E77F7A33E4CA98C19A9DC6722A29D4FFC@EXCHANGE.corp.perceptron.com

See Connor's comment, which explains pl/sql array optimization.

-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On \ Behalf Of Tim Onions
Sent: Tuesday, January 10, 2006 10:08 AM To: k.sriramkumar_at_gmail.com
Cc: Oracle-L_at_freelists.org
Subject: Re: LIOs from 10g when using CPU_TEST.SQL

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
>To: att755_at_hotmail.com
>CC: Oracle-L_at_freelists.org
>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

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



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

Received on Tue Jan 10 2006 - 16:15:03 CST