CODEWITHSUNDEEP
oracle-databasestored-proceduresoracle11g
Mike
Mike

Reputation: 105

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 many years of procedures in it. The goal is to quickly identify candidates for retirement.

Thanks, Mike

Upvotes: 3

Views: 11851

Answers (1)

Adam Musch
Adam Musch

Reputation: 13583

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.

Upvotes: 3

Related Questions