如何知道 Oracle 数据库中正在运行哪些存储过程？
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/1105946/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
How to know which stored procedures are running in an Oracle database?
提问by gerferra
I need to know which stored procedures are running. It's not an option to "mark" the stored procedures changing their source.
我需要知道哪些存储过程正在运行。“标记”存储过程更改其源不是一个选项。
Thank you very much.
非常感谢。
回答by Rob van Wijk
This blogpost of mine tells you all about it: http://rwijk.blogspot.com/2008/11/executingpackagessql.html
我的这篇博文告诉你一切：http: //rwijk.blogspot.com/2008/11/executingpackagessql.html
Regards, Rob.
问候，罗伯。
回答by Pop
Not sure about doing that for the entire database, but did you try using DBMS_TRACE?
不确定是否对整个数据库执行此操作，但您是否尝试使用 DBMS_TRACE？
http://download.oracle.com/docs/cd/B19306_01/appdev.102/b14258/d_trace.htm#CACEIHAH
http://download.oracle.com/docs/cd/B19306_01/appdev.102/b14258/d_trace.htm#CACEIHAH
