开发者

last time procedure executed in Oracle 11g

Is it possible to know when a stored procedure was last executed? I'm using Oracle 11g.

I've got an old app that has ma开发者_高级运维ny years of procedures in it. The goal is to quickly identify candidates for retirement.

Thanks, Mike


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 SESSION on those, using the DBA_AUDIT_TRAIL data dictionary view to prune the list over time -- and NOAUDIT EXECUTE those objects which get used.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜