tag:blogger.com,1999:blog-7395977411859619892.post8933341258550499107..comments2024-01-30T09:21:06.579+01:00Comments on About Oracle: executing_packages.sqlRob van Wijkhttp://www.blogger.com/profile/00499478359372903250noreply@blogger.comBlogger6125tag:blogger.com,1999:blog-7395977411859619892.post-48474082771442547972008-11-25T23:53:00.000+01:002008-11-25T23:53:00.000+01:00But your suggestion is not a solution. That was th...But your suggestion is not a solution. That was the point I was unsuccessfully trying to make.<BR/><BR/>You can try this test on 11g, to see why these columns won't always help you:<BR/><BR/>rwijk@ORA11GR1> create package pck3<BR/> 2 as<BR/> 3 procedure test;<BR/> 4 end pck3;<BR/> 5 /<BR/><BR/>Package is aangemaakt.<BR/><BR/>rwijk@ORA11GR1> create package body pck3<BR/> 2 asRob van Wijkhttps://www.blogger.com/profile/00499478359372903250noreply@blogger.comtag:blogger.com,1999:blog-7395977411859619892.post-40125252267476680592008-11-25T17:15:00.000+01:002008-11-25T17:15:00.000+01:00Yes this solution of course is more comprehensive ...Yes this solution of course is more comprehensive as opposed to that out of the box one :)Gints Plivnahttps://www.blogger.com/profile/17716037729002528529noreply@blogger.comtag:blogger.com,1999:blog-7395977411859619892.post-33754269487954012892008-11-23T19:13:00.000+01:002008-11-23T19:13:00.000+01:00Hi Gints,Thanks, I hadn't noticed these columns ye...Hi Gints,<BR/><BR/>Thanks, I hadn't noticed these columns yet. Also plsql_entry_object_id and plsql_entry_subprogram_id are nice. Although these four columns only give the top and bottom packages of the stack being executed. All packages in between will go off the radar. The view v_executing_packages will show those, so it is still worth having.<BR/><BR/>Regards,<BR/>Rob.Rob van Wijkhttps://www.blogger.com/profile/00499478359372903250noreply@blogger.comtag:blogger.com,1999:blog-7395977411859619892.post-83167569845912662422008-11-23T19:09:00.000+01:002008-11-23T19:09:00.000+01:00Hi Laurent,Interesting. 11gR2's editions will prob...Hi Laurent,<BR/><BR/>Interesting. 11gR2's editions will probably alleviate this problem. I'm curious ...<BR/><BR/>Regards,<BR/>Rob.Rob van Wijkhttps://www.blogger.com/profile/00499478359372903250noreply@blogger.comtag:blogger.com,1999:blog-7395977411859619892.post-72515264457282967672008-11-23T16:31:00.000+01:002008-11-23T16:31:00.000+01:00Time to upgrade to 11g ;) PLSQL_OBJECT_ID, PLSQL_S...Time to upgrade to 11g ;) PLSQL_OBJECT_ID, PLSQL_SUBPROGRAM_ID in v$session would help.Gints Plivnahttps://www.blogger.com/profile/17716037729002528529noreply@blogger.comtag:blogger.com,1999:blog-7395977411859619892.post-30345947155140686192008-11-23T09:30:00.000+01:002008-11-23T09:30:00.000+01:00there is also something like dbms_ddl.execute_para...there is also something like dbms_ddl.execute_parallel but since I have no access to the 11gr2 software I am not sure how it worksLaurent Schneiderhttps://www.blogger.com/profile/13833048234373264017noreply@blogger.com