RE: Ouch .... dbms_utility.format_call_stack in 11.2
Date: Wed, 27 Jul 2011 19:41:30 +0000
Message-ID: <6D9F00643B733E489E419CB485C966270CC938_at_IRVMBX01.innout.corp>
Works fine on my 11.2.0.2 Patch 4 on Windows Server 2003R2 . But I just recently upgraded from 11.2.0.1 to 11.2.0.2 and I ran into 4 bugs, some pretty bad. I got patches for two of them, the other two I just have band aids on. I would be careful of 11.2.0.2, and I would suggest running the latest patchset. I know we are currently not but are working on.
Jeff Chirco | Database Administrator
o 949 509 6374
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Connor McDonald
Sent: Tuesday, July 26, 2011 7:50 PM
To: oracle-l_at_freelists.org
Subject: Ouch .... dbms_utility.format_call_stack in 11.2
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<mailto: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 - 14:41:30 CDT