上次在 Oracle 11g 中执行的过程
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/3479878/
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
last time procedure executed in Oracle 11g
提问by Mike
Is it possible to know when a stored procedure was last executed? I'm using Oracle 11g.
是否可以知道上次执行存储过程的时间？我正在使用 Oracle 11g。
I've got an old app that has many years of procedures in it. The goal is to quickly identify candidates for retirement.
我有一个旧的应用程序，里面有很多年的程序。目标是快速确定退休候选人。
Thanks, Mike
谢谢，迈克
采纳答案by Adam Musch
There's nothing in the data dictionary that records when a package/procedure/function was last executed.
数据字典中没有记录上次执行包/过程/函数的时间。
If you have candidates for deletion, you could AUDIT EXECUTE BY SESSIONon those, using the DBA_AUDIT_TRAILdata dictionary view to prune the list over time -- and NOAUDIT EXECUTEthose objects which get used.
如果您有删除的候选对象，您可以AUDIT EXECUTE BY SESSION使用DBA_AUDIT_TRAIL数据字典视图随着时间的推移修剪列表——以及NOAUDIT EXECUTE那些被使用的对象。
