查看存储过程执行日志

SQL查看存储过程执行日志：

select t.sql_id,
    t.sql_text,
    s.plan_hash_value,
    s.optimizer_cost,
    s.executions_total,
    s.elapsed_time_total,
    s.disk_reads_total,
    s.buffer_gets_total
from DBA_HIST_SQLSTAT s, DBA_HIST_SQLTEXT t
where s.sql_id=t.sql_id
and t.sql_text like'%存储过程名称%';