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

From: Niall Litchfield <niall.litchfield_at_gmail.com>
Date: Wed, 27 Jul 2011 07:17:33 +0100
Message-ID: <CABe10sYhUQZe1Eg_HsG33G_=9YeT4iPWAX-7yePS3QHv70arRw_at_mail.gmail.com>

Same also reproduces on Linux

SQL> select banner from v$version;

BANNER

---

Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - Production PL/SQL Release 11.2.0.2.0 - Production
CORE 11.2.0.2.0 Production
TNS for Linux: 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:00.15

On Wed, Jul 27, 2011 at 7:10 AM, Niall Litchfield < niall.litchfield_at_gmail.com> wrote:

> In a word no.
>
> SYS _at_ NIALL1 >select banner 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 64-bit Windows: Version 11.2.0.2.0 - Production
> NLSRTL Version 11.2.0.2.0 - Production
>
> SYS _at_ NIALL1 >set timing on
> SYS _at_ NIALL1 >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:00.17
> SYS _at_ NIALL1 >
>
>
> On Wed, Jul 27, 2011 at 3:49 AM, Connor McDonald <
> mcdonald.connor_at_gmail.com> wrote:
>
>> SQL> connect scott/tiger_at_db11107
>> Connected.
>>
>> SQL> select * from v$version;
>>
>> BANNER
>>
>> --------------------------------------------------------------------------------
>> Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit
>> Production
>> PL/SQL Release 11.1.0.7.0 - Production
>> CORE 11.1.0.7.0 Production
>> TNS for IBM/AIX RISC System/6000: Version 11.1.0.7.0 - Production
>> NLSRTL Version 11.1.0.7.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:00.06
>>
>>
>> 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"
>>
>
>
>
> --
> Niall Litchfield
> Oracle DBA
> http://www.orawin.info
>

-- 
Niall Litchfield
Oracle DBA
http://www.orawin.info

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

Received on Wed Jul 27 2011 - 01:17:33 CDT