开发者

last time procedure executed in Oracle 11g

开发者 https://www.devze.com 2023-01-12 00:40 出处:网络
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 can

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

精彩评论

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