All geek questions in one place

Last procedure performed in Oracle 11g

Can I find out when the last stored procedure was executed? I am using Oracle 11g.

I have an old application that has multi-year procedures. The goal is to quickly identify candidates for retirement.

Thanks Mike

+3
source share
1 answer

The data dictionary does not contain anything when it is written when the last time the package / procedure / function was executed.

If you have candidates for deletion, you can address AUDIT EXECUTE BY SESSIONthem using the data dictionary view DBA_AUDIT_TRAILto shorten the list in time - and NOAUDIT EXECUTEthose objects that will be used.

+3

Source: https://habr.com/ru/post/1759583/

More articles:


All Articles