24/09/2014, 10:26
|
| | | Fecha de Ingreso: enero-2010
Mensajes: 29
Antigüedad: 14 años, 10 meses Puntos: 3 | |
| Respuesta: Consulta de historial de ejecucion de Procedures
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. |