Determine an procedure's/function's last execution timestamp?

Nuerni

Hi,

Is it possible to get the last timestamp (absolute date and time) of an procedure's/function's (in packages) execution?

Karthick2003

You can try using v$sql. But data is not persistent there.

SQL> create or replace procedure my_test_proc
  2  as
  3     l dual.dummy%type;
  4  begin
  5     select dummy into l from dual;
  6  end;
  7  /

Procedure created.

SQL> exec my_test_proc

PL/SQL procedure successfully completed.


SQL> select first_load_time,last_load_time,sql_text from v$sql where lower(sql_text) like '%my_test_proc%
  2  /

FIRST_LOAD_TIME     LAST_LOAD_TIME
------------------- -------------------
SQL_TEXT
---------------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------
2008-11-12/17:04:06 2008-11-12/17:04:06
BEGIN my_test_proc; END;

Boneist

Not unless you're recording it somewhere, or perhaps there's some auditing going on.