Re: Ouch .... dbms_utility.format_call_stack in 11.2

From: Connor McDonald <mcdonald.connor_at_gmail.com>
Date: Wed, 27 Jul 2011 13:58:27 +0800
Message-ID: <CAB=aETDe3=G_C2hoCXonbKKkkzQjG6bQ+OsEK7C1-y2L7q24ew_at_mail.gmail.com>

Well, that's just for the benchmark...the *real* usage is in plsql modules where we heavily instrument our code. Lots of instrumentation = lots of calls to dbms_utility.format_call_stack....

... and 11.2 didn't like that :-)

On Wed, Jul 27, 2011 at 10:55 AM, Chitale, Hemant Krishnarao < Hemant.Chitale_at_sc.com> wrote:

> **
>
> ** **
>
> I can't test this right now …………****
>
> ** **
>
> but just wondering …. what requirements OR prior experiences led you to
> want to test running format_call_stack 10,000 times in a tight loop ?****
>
> ** **
>
>
> Hemant K Chitale
>
> ****
> ------------------------------
>
> *From:* **oracle-l-bounce_at_freelists.org** [mailto:**
> oracle-l-bounce_at_freelists.org**] *On Behalf Of *Connor McDonald
> *Sent:* Wednesday, July 27, 2011 10:50 AM
> *To:* **oracle-l_at_freelists.org**
> *Subject:* Ouch .... dbms_utility.format_call_stack in 11.2****
>
> ** **
>
> SQL> connect scott/tiger_at_db11202****
>
> Connected.
> ****
>
>
>
> ****
>
> SQL> select * from v$version;
> ****
>
>
>
> ****
>
> BANNER
> ****
>
>
> --------------------------------------------------------------------------------
> ****
>
> Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit
> Production
> ****
>
> PL/SQL Release 11.2.0.2.0 - Production
> ****
>
> CORE 11.2.0.2.0 Production
> ****
>
> TNS for IBM/AIX RISC System/6000: Version 11.2.0.2.0 - Production
> ****
>
> NLSRTL Version 11.2.0.2.0 - Production
> ****
>
>
>
> ****
>
> SQL> set timing on
> ****
>
> SQL> declare
> ****
>
> 2 x varchar2(1000);
> ****
>
> 3 begin
> ****
>
> 4 for i in 1 .. 10000 loop
> ****
>
> 5 x := dbms_utility.format_call_stack;
> ****
>
> 6 end loop;
> ****
>
> 7 end;
> ****
>
> 8 /
> ****
>
>
>
> ****
>
> PL/SQL procedure successfully completed.
> ****
>
>
>
> ****
>
> Elapsed: 00:00:03.31 <<======== !!!!!
> ****
>
> ** **
>
> ** **
>
> Do people see similar on their own platforms ?****
>
> ** **
>
> Cheers****
>
> Connor****
>
>
> --
> Connor McDonald
> ===========================
> email: connor_mcdonald_at_yahoo.com
> web: http://www.oracledba.co.uk
>
> "Semper in excremento, sole profundum qui variat"****
>
> This email and any attachments are confidential and may also be privileged.
> If you are not the addressee, do not disclose, copy, circulate or in any
> other way use or rely on the information contained in this email or any
> attachments. If received in error, notify the sender immediately and delete
> this email and any attachments from your system. Emails cannot be guaranteed
> to be secure or error free as the message and any attachments could be
> intercepted, corrupted, lost, delayed, incomplete or amended. Standard
> Chartered PLC and its subsidiaries do not accept liability for damage caused
> by this email or any attachments and may monitor email traffic.
>
> Standard Chartered PLC is incorporated in England with limited liability
> under company number 966425 and has its registered office at 1 Aldermanbury
> Square, London, EC2V 7SB.
>
> Standard Chartered Bank ("SCB") is incorporated in England with limited
> liability by Royal Charter 1853, under reference ZC18. The Principal Office
> of SCB is situated in England at 1 Aldermanbury Square, London EC2V 7SB. In
> the United Kingdom, SCB is authorised and regulated by the Financial
> Services Authority under FSA register number 114276.
>
> If you are receiving this email from SCB outside the UK, please click
> http://www.standardchartered.com/global/email_disclaimer.html to refer to
> the information on other jurisdictions.
>

-- 
Connor McDonald
===========================
email: connor_mcdonald_at_yahoo.com
web:   http://www.oracledba.co.uk

"Semper in excremento, sole profundum qui variat"

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

Received on Wed Jul 27 2011 - 00:58:27 CDT