实时具有PL/SQL输出 [英] Have PL/SQL Outputs in Real Time

问题描述

是否可以实时从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输出的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！