• <i id='d3CgR'><tr id='d3CgR'><dt id='d3CgR'><q id='d3CgR'><span id='d3CgR'><b id='d3CgR'><form id='d3CgR'><ins id='d3CgR'></ins><ul id='d3CgR'></ul><sub id='d3CgR'></sub></form><legend id='d3CgR'></legend><bdo id='d3CgR'><pre id='d3CgR'><center id='d3CgR'></center></pre></bdo></b><th id='d3CgR'></th></span></q></dt></tr></i><div id='d3CgR'><tfoot id='d3CgR'></tfoot><dl id='d3CgR'><fieldset id='d3CgR'></fieldset></dl></div>

        <legend id='d3CgR'><style id='d3CgR'><dir id='d3CgR'><q id='d3CgR'></q></dir></style></legend>
          <bdo id='d3CgR'></bdo><ul id='d3CgR'></ul>

      1. <small id='d3CgR'></small><noframes id='d3CgR'>

        <tfoot id='d3CgR'></tfoot>

        具有实时 PL/SQL 输出

        Have PL/SQL Outputs in Real Time(具有实时 PL/SQL 输出)

          <small id='QEv4Q'></small><noframes id='QEv4Q'>

          <legend id='QEv4Q'><style id='QEv4Q'><dir id='QEv4Q'><q id='QEv4Q'></q></dir></style></legend>
              <tbody id='QEv4Q'></tbody>
              <bdo id='QEv4Q'></bdo><ul id='QEv4Q'></ul>
              <i id='QEv4Q'><tr id='QEv4Q'><dt id='QEv4Q'><q id='QEv4Q'><span id='QEv4Q'><b id='QEv4Q'><form id='QEv4Q'><ins id='QEv4Q'></ins><ul id='QEv4Q'></ul><sub id='QEv4Q'></sub></form><legend id='QEv4Q'></legend><bdo id='QEv4Q'><pre id='QEv4Q'><center id='QEv4Q'></center></pre></bdo></b><th id='QEv4Q'></th></span></q></dt></tr></i><div id='QEv4Q'><tfoot id='QEv4Q'></tfoot><dl id='QEv4Q'><fieldset id='QEv4Q'></fieldset></dl></div>

                1. <tfoot id='QEv4Q'></tfoot>
                  本文介绍了具有实时 PL/SQL 输出的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着跟版网的小编来一起学习吧!

                  问题描述

                  是否可以实时获得来自 PL/SQL 的输出?我有一个非常大的包裹,运行了一个多小时,我想看看包裹在特定时间的位置.

                  Is it possible to have Outputs from PL/SQL in real time? I have a pretty huge package that runs for more than an hour and I'd like to see where the package is at a particular time.

                  无论如何,我目前使用一个日志表来做这件事,每次运行都会填满数百个日志描述,我只是好奇这是否可能.

                  Anyways, I currently do this with a log table, which gets filled up with hundreds of log descriptions per run, I'm just curious if this is possible.

                  谢谢!

                  推荐答案

                  我不知道这是否正是您想要的,但我使用 dbms_application_info.set_module 来查看我的包在哪里.

                  I don't know if this is exactly what you want but I use dbms_application_info.set_module to see where my package is.

                  dbms_application_info.set_module(module_name => 'Conversion job',
                                                   action_name => 'updating table_x'); 
                  

                  v$session 的查询将显示程序的哪一部分正在运行.

                  A query on v$session will show you which part of the procedure is running.

                  这篇关于具有实时 PL/SQL 输出的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持跟版网!

                  本站部分内容来源互联网,如果有图片或者内容侵犯了您的权益,请联系我们,我们会在确认后第一时间进行删除!

                  相关文档推荐

                  How do I split flat file data and load into parent-child tables in database?(如何拆分平面文件数据并加载到数据库中的父子表中?)
                  How to import CSV into sqlite using RSqlite?(如何使用 RSqlite 将 CSV 导入 sqlite?)
                  Import CSV to Update rows in table(导入 CSV 以更新表中的行)
                  Importing MaxMind#39;s GeoLite2 to MySQL(将 MaxMind 的 GeoLite2 导入 MySQL)
                  Import / Export database with SQL Server Server Management Studio(使用 SQL Server Server Management Studio 导入/导出数据库)
                  How do you import a large MS SQL .sql file?(如何导入大型 MS SQL .sql 文件?)
                  <legend id='ORCHH'><style id='ORCHH'><dir id='ORCHH'><q id='ORCHH'></q></dir></style></legend>

                    <small id='ORCHH'></small><noframes id='ORCHH'>

                    1. <tfoot id='ORCHH'></tfoot>
                          <i id='ORCHH'><tr id='ORCHH'><dt id='ORCHH'><q id='ORCHH'><span id='ORCHH'><b id='ORCHH'><form id='ORCHH'><ins id='ORCHH'></ins><ul id='ORCHH'></ul><sub id='ORCHH'></sub></form><legend id='ORCHH'></legend><bdo id='ORCHH'><pre id='ORCHH'><center id='ORCHH'></center></pre></bdo></b><th id='ORCHH'></th></span></q></dt></tr></i><div id='ORCHH'><tfoot id='ORCHH'></tfoot><dl id='ORCHH'><fieldset id='ORCHH'></fieldset></dl></div>
                            <bdo id='ORCHH'></bdo><ul id='ORCHH'></ul>
                              <tbody id='ORCHH'></tbody>