具有实时 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.
相关文章