Well, that's just for the benchmark...the *real* usage is in plsql modules where we heavily instrument our code. Lots of instrumentation = lots of calls to dbms_utility.format_call_stack.... ... and 11.2 didn't like that :-) On Wed, Jul 27, 2011 at 10:55 AM, Chitale, Hemant Krishnarao < Hemant.Chitale@xxxxxx> wrote: > ** > > ** ** > > I can't test this right now …………**** > > ** ** > > but just wondering …. what requirements OR prior experiences led you to > want to test running format_call_stack 10,000 times in a tight loop ?**** > > ** ** > > > Hemant K Chitale > > **** > ------------------------------ > > *From:* **oracle-l-bounce@xxxxxxxxxxxxx** [mailto:** > oracle-l-bounce@xxxxxxxxxxxxx**] *On Behalf Of *Connor McDonald > *Sent:* Wednesday, July 27, 2011 10:50 AM > *To:* **oracle-l@xxxxxxxxxxxxx** > *Subject:* Ouch .... dbms_utility.format_call_stack in 11.2**** > > ** ** > > 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 > web: http://www.oracledba.co.uk > > "Semper in excremento, sole profundum qui variat"**** > > This email and any attachments are confidential and may also be privileged. > If you are not the addressee, do not disclose, copy, circulate or in any > other way use or rely on the information contained in this email or any > attachments. If received in error, notify the sender immediately and delete > this email and any attachments from your system. Emails cannot be guaranteed > to be secure or error free as the message and any attachments could be > intercepted, corrupted, lost, delayed, incomplete or amended. Standard > Chartered PLC and its subsidiaries do not accept liability for damage caused > by this email or any attachments and may monitor email traffic. > > Standard Chartered PLC is incorporated in England with limited liability > under company number 966425 and has its registered office at 1 Aldermanbury > Square, London, EC2V 7SB. > > Standard Chartered Bank ("SCB") is incorporated in England with limited > liability by Royal Charter 1853, under reference ZC18. The Principal Office > of SCB is situated in England at 1 Aldermanbury Square, London EC2V 7SB. In > the United Kingdom, SCB is authorised and regulated by the Financial > Services Authority under FSA register number 114276. > > If you are receiving this email from SCB outside the UK, please click > http://www.standardchartered.com/global/email_disclaimer.html to refer to > the information on other jurisdictions. > -- Connor McDonald =========================== email: connor_mcdonald@xxxxxxxxx web: http://www.oracledba.co.uk "Semper in excremento, sole profundum qui variat"