HOW TO FIND THE LAST EXECUTION TIME OF THE PROCEDURE?

Select systimestamp, owner, obj_name, action_name from dba_audit_trail;

NOTE: Auditing is disabled by default

CONNECT sys/password AS SYSDBA;

--ALTER SYSTEM SET audit_trail=db SCOPE=SPFILE;

AUDIT ALL BY MIS BY ACCESS;

AUDIT SELECT TABLE, UPDATE TABLE, INSERT TABLE, DELETE TABLE BY MIS BY ACCESS;

AUDIT EXECUTE PROCEDURE BY MIS BY ACCESS;