Simple OWB Runtime Report

A slight variation on some SQL I posted a few months back:

For MAPPING executions list the Start TIme, clock time in seconds, number of records selected, and the throughput.
select
ae.created_on start_time,
ae.object_name map_name,
ae.elapse_time time_in_seconds,
mr.number_records_selected total_num_records,
trunc(mr.number_records_selected / ae.elapse_time) records_per_second
from
all_rt_audit_executions ae,
all_rt_audit_map_runs mr
where
1 = 1
and ae.execution_audit_id = mr.execution_audit_id
and ae.elapse_time != 0
order by 1

WARNING: While I think it poses little risk, use at your own risk and ensure it’s right for your environment… Same thing everyone says about code/SQL posted on the internet.

Leave a Reply

Your email address will not be published.