具有实时 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屋！