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

Yup - even AIX 11.2.0.1 is fine..... Just 11.2.0.2.

I mean seriously....what could have changed in "format_call_stack" since.....say.....version 7

:-)

On Wed, Jul 27, 2011 at 2:10 PM, 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
>

-- 
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