Consulta de historial de ejecucion de Procedures

[yong321]

See if you can find the procedure in v$sql (or v$sqlarea or v$sqlstats). There's the column "executions". If not, and if it's because the shared pool has been purged or the SQL simply was aged out, see if dba_hist_sqlstats has it. There's the column executions_total and executions_delta in that view.

Otherwise, set up audit on the execution of the procedure.