RE: Ouch .... dbms_utility.format_call_stack in 11.2
- From: Jeff Chirco <JChirco@xxxxxxxxxx>
- To: "mcdonald.connor@xxxxxxxxx" <mcdonald.connor@xxxxxxxxx>, "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 27 Jul 2011 19:41:30 +0000
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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Connor McDonald
Sent: Tuesday, July 26, 2011 7:50 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: Ouch .... dbms_utility.format_call_stack in 11.2
SQL> connect scott/tiger@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@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@xxxxxxxxx<mailto:connor_mcdonald@xxxxxxxxx>
web: http://www.oracledba.co.uk
"Semper in excremento, sole profundum qui variat"
Other related posts:
