title: How do I find out when a stored procedure was last executed in Oracle?
body: <p>Is there any way of finding the last execution time of a stored procedure in Oracle? I have inherited a DB and one of the tables suddenly has millions of duplicates for an end of period total where it usually would only have one row. I think the data is probably inserted by a stored procedure and I want to find when that procedure last executed or what it is that triggers the procedure to run.</p>
  
  <p>I am not a DBA but have quite good SQL skills and so have had this one landed on me whilst the DBA is on leave. I have tried looking at the procedure properties and references but can find no clues. I saw a question that asked about last update and compile times and tried to see if more information was available by selecting all columns as in the code below but with no joy.</p>
  
  <pre><code>SELECT *
  FROM USER_OBJECTS
  WHERE OBJECT_TYPE = 'PROCEDURE'
  AND OBJECT_NAME = 'MY_PROC_NAME';
  </code></pre>
  
  <p>In an ideal world I was hoping to find a table showing me the last x executions of stored procedures with execution time and what triggered them.</p>