How To Know The Last Executed Procedure?

1.	How To Know The Last Executed Procedure?
Answer» Execute procedure name (parameter1,parameter2) SELECT timestamps, owner, obj_name, action_name from dba_audit_trail;this STATEMENT gives LAST executed time for procedure , FUNCTION & PACKAGE. Execute procedure name (parameter1,parameter2) Select timestamps, owner, obj_name, action_name from dba_audit_trail;this statement gives last executed time for procedure , function & package.

Answer»

Execute procedure name (parameter1,parameter2)

SELECT timestamps, owner, obj_name, action_name from dba_audit_trail;this STATEMENT gives LAST executed time for procedure , FUNCTION & PACKAGE.

Execute procedure name (parameter1,parameter2)

Select timestamps, owner, obj_name, action_name from dba_audit_trail;this statement gives last executed time for procedure , function & package.

Discussion