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

From: Niall Litchfield <niall.litchfield_at_gmail.com>
Date: Wed, 27 Jul 2011 07:10:49 +0100
Message-ID: <CABe10sb0NY6L+VJiwZn2FfEvSazu=VHbUSQ8F4YHegbLgTpOGQ_at_mail.gmail.com>

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

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

Received on Wed Jul 27 2011 - 01:10:49 CDT